摘要：
public interface IDataSet { /// <summary> /// 与数据库数据项相关联的数据 /// </summary> string LinkProperty { get; set; } /// <summary> /// 与数据关联的表名 /// </summary> string LinkObject { get; set; }public enum DataType { Never, //不验证 String, //字符串 Int, //整数 IntPostive, //大于0的整数 IntZeroPostiv 阅读全文
摘要：
public class MYORM { public String MysqlStr = ""; public MYORM() { this.MysqlStr = "Select * from Userinfo where "; } public MYORM(String SQLStr) { if (SQLStr.ToString().Length > 0) { this.MysqlStr = this.MysqlStr + SQLStr; } else { this.MysqlStr = "Select * from Userinfo 阅读全文
摘要：
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using MySql.Data.MySqlClient;using System.Data;namespace WindowsFormsApplication9{ public class MYSQLHELPER { public DataSet Ds = new DataSet(); public DataTable Dt = new DataTable(); public 阅读全文
摘要：
SELECT concat( right(year(lot_info.start_date),2), date_format(lot_info.start_date,'%m') ) A5BSYM, 'L2' A5JGCD,substring( prod_lst.PROD_PN,2,3) A5KSCD,case when prod_lst.is_mat=1 then '' when prod_lst.is_mat=0 then left( prod_lst.pn_desc,8) end A5TYPE , prod_lst.pn_desc A5ITD 阅读全文