/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.mp GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select BM,DWMC,DH,ZTIDH,FAX,DZ,LXR,YB,QCJE,SRJE,FCJE,JCJE,YE,FCSL,ML,QCYE,HM,JB,XXDWMC,XXDZ,KHH,ZH,SH,SX,SPBH,LB,JYFW,SSBM,DS,RQ,RQ1,ID,KHZT,KHBM,WXHM,QQ,DZYJ,province_id,province_name,city_id,city_name,period_start,period_start_date,Is_stop from mp ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32, 11)
};
parameters[0].Value = ID;
FMS_Model.mp model = new FMS_Model.mp();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.mp model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.mp model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(FMS_Model.mp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into mp(");
strSql.Append("BM,DWMC,DH,ZTIDH,FAX,DZ,LXR,YB,QCJE,SRJE,FCJE,JCJE,YE,FCSL,ML,QCYE,HM,JB,XXDWMC,XXDZ,KHH,ZH,SH,SX,SPBH,LB,JYFW,SSBM,DS,RQ,RQ1,ID,KHZT,KHBM,WXHM,QQ,DZYJ,province_id,province_name,city_id,city_name,period_start,period_start_date,Is_stop)");
strSql.Append(" values (");
strSql.Append("@BM,@DWMC,@DH,@ZTIDH,@FAX,@DZ,@LXR,@YB,@QCJE,@SRJE,@FCJE,@JCJE,@YE,@FCSL,@ML,@QCYE,@HM,@JB,@XXDWMC,@XXDZ,@KHH,@ZH,@SH,@SX,@SPBH,@LB,@JYFW,@SSBM,@DS,@RQ,@RQ1,@ID,@KHZT,@KHBM,@WXHM,@QQ,@DZYJ,@province_id,@province_name,@city_id,@city_name,@period_start,@period_start_date,@Is_stop)");
MySqlParameter[] parameters =
{
new MySqlParameter("@BM", MySqlDbType.VarChar, 50),
new MySqlParameter("@DWMC", MySqlDbType.VarChar, 60),
new MySqlParameter("@DH", MySqlDbType.VarChar, 50),
new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 3),
new MySqlParameter("@FAX", MySqlDbType.VarChar, 50),
new MySqlParameter("@DZ", MySqlDbType.VarChar, 50),
new MySqlParameter("@LXR", MySqlDbType.VarChar, 50),
new MySqlParameter("@YB", MySqlDbType.VarChar, 50),
new MySqlParameter("@QCJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@SRJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@FCJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@JCJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@YE", MySqlDbType.Decimal, 15),
new MySqlParameter("@FCSL", MySqlDbType.Decimal, 15),
new MySqlParameter("@ML", MySqlDbType.Decimal, 15),
new MySqlParameter("@QCYE", MySqlDbType.Decimal, 15),
new MySqlParameter("@HM", MySqlDbType.Decimal, 18),
new MySqlParameter("@JB", MySqlDbType.VarChar, 50),
new MySqlParameter("@XXDWMC", MySqlDbType.VarChar, 60),
new MySqlParameter("@XXDZ", MySqlDbType.VarChar, 60),
new MySqlParameter("@KHH", MySqlDbType.VarChar, 50),
new MySqlParameter("@ZH", MySqlDbType.VarChar, 50),
new MySqlParameter("@SH", MySqlDbType.VarChar, 50),
new MySqlParameter("@SX", MySqlDbType.Decimal, 15),
new MySqlParameter("@SPBH", MySqlDbType.VarChar, 50),
new MySqlParameter("@LB", MySqlDbType.VarChar, 50),
new MySqlParameter("@JYFW", MySqlDbType.VarChar, 255),
new MySqlParameter("@SSBM", MySqlDbType.VarChar, 50),
new MySqlParameter("@DS", MySqlDbType.Decimal, 15),
new MySqlParameter("@RQ", MySqlDbType.DateTime),
new MySqlParameter("@RQ1", MySqlDbType.DateTime),
new MySqlParameter("@ID", MySqlDbType.Int32, 11),
new MySqlParameter("@KHZT", MySqlDbType.VarChar, 50),
new MySqlParameter("@KHBM", MySqlDbType.VarChar, 50),
new MySqlParameter("@WXHM", MySqlDbType.VarChar, 50),
new MySqlParameter("@QQ", MySqlDbType.VarChar, 50),
new MySqlParameter("@DZYJ", MySqlDbType.VarChar, 50),
new MySqlParameter("@province_id", MySqlDbType.Int32, 11),
new MySqlParameter("@province_name", MySqlDbType.VarChar, 120),
new MySqlParameter("@city_id", MySqlDbType.Int32, 11),
new MySqlParameter("@city_name", MySqlDbType.VarChar, 120),
new MySqlParameter("@period_start", MySqlDbType.Decimal, 18),
new MySqlParameter("@period_start_date", MySqlDbType.DateTime),
new MySqlParameter("@Is_stop", MySqlDbType.Int16, 2)
};
parameters[0].Value = model.BM;
parameters[1].Value = model.DWMC;
parameters[2].Value = model.DH;
parameters[3].Value = model.ZTIDH;
parameters[4].Value = model.FAX;
parameters[5].Value = model.DZ;
parameters[6].Value = model.LXR;
parameters[7].Value = model.YB;
parameters[8].Value = model.QCJE;
parameters[9].Value = model.SRJE;
parameters[10].Value = model.FCJE;
parameters[11].Value = model.JCJE;
parameters[12].Value = model.YE;
parameters[13].Value = model.FCSL;
parameters[14].Value = model.ML;
parameters[15].Value = model.QCYE;
parameters[16].Value = model.HM;
parameters[17].Value = model.JB;
parameters[18].Value = model.XXDWMC;
parameters[19].Value = model.XXDZ;
parameters[20].Value = model.KHH;
parameters[21].Value = model.ZH;
parameters[22].Value = model.SH;
parameters[23].Value = model.SX;
parameters[24].Value = model.SPBH;
parameters[25].Value = model.LB;
parameters[26].Value = model.JYFW;
parameters[27].Value = model.SSBM;
parameters[28].Value = model.DS;
parameters[29].Value = model.RQ;
parameters[30].Value = model.RQ1;
parameters[31].Value = model.ID;
parameters[32].Value = model.KHZT;
parameters[33].Value = model.KHBM;
parameters[34].Value = model.WXHM;
parameters[35].Value = model.QQ;
parameters[36].Value = model.DZYJ;
parameters[37].Value = model.province_id;
parameters[38].Value = model.province_name;
parameters[39].Value = model.city_id;
parameters[40].Value = model.city_name;
parameters[41].Value = model.period_start;
parameters[42].Value = model.period_start_date;
parameters[43].Value = model.Is_stop;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.mp DataRowToModel(DataRow row)
{
FMS_Model.mp model = new FMS_Model.mp();
if (row != null)
{
if (row["BM"] != null)
{
model.BM = row["BM"].ToString();
}
if (row["DWMC"] != null)
{
model.DWMC = row["DWMC"].ToString();
}
if (row["DH"] != null)
{
model.DH = row["DH"].ToString();
}
if (row["ZTIDH"] != null && row["ZTIDH"].ToString() != "")
{
model.ZTIDH = decimal.Parse(row["ZTIDH"].ToString());
}
if (row["FAX"] != null)
{
model.FAX = row["FAX"].ToString();
}
if (row["DZ"] != null)
{
model.DZ = row["DZ"].ToString();
}
if (row["LXR"] != null)
{
model.LXR = row["LXR"].ToString();
}
if (row["YB"] != null)
{
model.YB = row["YB"].ToString();
}
if (row["QCJE"] != null && row["QCJE"].ToString() != "")
{
model.QCJE = decimal.Parse(row["QCJE"].ToString());
}
if (row["SRJE"] != null && row["SRJE"].ToString() != "")
{
model.SRJE = decimal.Parse(row["SRJE"].ToString());
}
if (row["FCJE"] != null && row["FCJE"].ToString() != "")
{
model.FCJE = decimal.Parse(row["FCJE"].ToString());
}
if (row["JCJE"] != null && row["JCJE"].ToString() != "")
{
model.JCJE = decimal.Parse(row["JCJE"].ToString());
}
if (row["YE"] != null && row["YE"].ToString() != "")
{
model.YE = decimal.Parse(row["YE"].ToString());
}
if (row["FCSL"] != null && row["FCSL"].ToString() != "")
{
model.FCSL = decimal.Parse(row["FCSL"].ToString());
}
if (row["ML"] != null && row["ML"].ToString() != "")
{
model.ML = decimal.Parse(row["ML"].ToString());
}
if (row["QCYE"] != null && row["QCYE"].ToString() != "")
{
model.QCYE = decimal.Parse(row["QCYE"].ToString());
}
if (row["HM"] != null && row["HM"].ToString() != "")
{
model.HM = decimal.Parse(row["HM"].ToString());
}
if (row["JB"] != null)
{
model.JB = row["JB"].ToString();
}
if (row["XXDWMC"] != null)
{
model.XXDWMC = row["XXDWMC"].ToString();
}
if (row["XXDZ"] != null)
{
model.XXDZ = row["XXDZ"].ToString();
}
if (row["KHH"] != null)
{
model.KHH = row["KHH"].ToString();
}
if (row["ZH"] != null)
{
model.ZH = row["ZH"].ToString();
}
if (row["SH"] != null)
{
model.SH = row["SH"].ToString();
}
if (row["SX"] != null && row["SX"].ToString() != "")
{
model.SX = decimal.Parse(row["SX"].ToString());
}
if (row["SPBH"] != null)
{
model.SPBH = row["SPBH"].ToString();
}
if (row["LB"] != null)
{
model.LB = row["LB"].ToString();
}
if (row["JYFW"] != null)
{
model.JYFW = row["JYFW"].ToString();
}
if (row["SSBM"] != null)
{
model.SSBM = row["SSBM"].ToString();
}
if (row["DS"] != null && row["DS"].ToString() != "")
{
model.DS = decimal.Parse(row["DS"].ToString());
}
if (row["RQ"] != null && row["RQ"].ToString() != "")
{
model.RQ = DateTime.Parse(row["RQ"].ToString());
}
if (row["RQ1"] != null && row["RQ1"].ToString() != "")
{
model.RQ1 = DateTime.Parse(row["RQ1"].ToString());
}
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["KHZT"] != null)
{
model.KHZT = row["KHZT"].ToString();
}
if (row["KHBM"] != null)
{
model.KHBM = row["KHBM"].ToString();
}
if (row["WXHM"] != null)
{
model.WXHM = row["WXHM"].ToString();
}
if (row["QQ"] != null)
{
model.QQ = row["QQ"].ToString();
}
if (row["DZYJ"] != null)
{
model.DZYJ = row["DZYJ"].ToString();
}
if (row["province_id"] != null && row["province_id"].ToString() != "")
{
model.province_id = int.Parse(row["province_id"].ToString());
}
if (row["province_name"] != null)
{
model.province_name = row["province_name"].ToString();
}
if (row["city_id"] != null && row["city_id"].ToString() != "")
{
model.city_id = int.Parse(row["city_id"].ToString());
}
if (row["city_name"] != null)
{
model.city_name = row["city_name"].ToString();
}
if (row["period_start"] != null && row["period_start"].ToString() != "")
{
model.period_start = decimal.Parse(row["period_start"].ToString());
}
if (row["period_start_date"] != null && row["period_start_date"].ToString() != "")
{
model.period_start_date = DateTime.Parse(row["period_start_date"].ToString());
}
if (row["Is_stop"] != null && row["Is_stop"].ToString() != "")
{
model.Is_stop = int.Parse(row["Is_stop"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.mp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update mp set ");
strSql.Append("BM=@BM,");
strSql.Append("DWMC=@DWMC,");
strSql.Append("DH=@DH,");
strSql.Append("ZTIDH=@ZTIDH,");
strSql.Append("FAX=@FAX,");
strSql.Append("DZ=@DZ,");
strSql.Append("LXR=@LXR,");
strSql.Append("YB=@YB,");
strSql.Append("QCJE=@QCJE,");
strSql.Append("SRJE=@SRJE,");
strSql.Append("FCJE=@FCJE,");
strSql.Append("JCJE=@JCJE,");
strSql.Append("YE=@YE,");
strSql.Append("FCSL=@FCSL,");
strSql.Append("ML=@ML,");
strSql.Append("QCYE=@QCYE,");
strSql.Append("HM=@HM,");
strSql.Append("JB=@JB,");
strSql.Append("XXDWMC=@XXDWMC,");
strSql.Append("XXDZ=@XXDZ,");
strSql.Append("KHH=@KHH,");
strSql.Append("ZH=@ZH,");
strSql.Append("SH=@SH,");
strSql.Append("SX=@SX,");
strSql.Append("SPBH=@SPBH,");
strSql.Append("LB=@LB,");
strSql.Append("JYFW=@JYFW,");
strSql.Append("SSBM=@SSBM,");
strSql.Append("DS=@DS,");
strSql.Append("RQ=@RQ,");
strSql.Append("RQ1=@RQ1,");
strSql.Append("KHZT=@KHZT,");
strSql.Append("KHBM=@KHBM,");
strSql.Append("WXHM=@WXHM,");
strSql.Append("QQ=@QQ,");
strSql.Append("DZYJ=@DZYJ,");
strSql.Append("province_id=@province_id,");
strSql.Append("province_name=@province_name,");
strSql.Append("city_id=@city_id,");
strSql.Append("city_name=@city_name,");
strSql.Append("period_start=@period_start,");
strSql.Append("period_start_date=@period_start_date,");
strSql.Append("Is_stop=@Is_stop");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@BM", MySqlDbType.VarChar, 50),
new MySqlParameter("@DWMC", MySqlDbType.VarChar, 60),
new MySqlParameter("@DH", MySqlDbType.VarChar, 50),
new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 3),
new MySqlParameter("@FAX", MySqlDbType.VarChar, 50),
new MySqlParameter("@DZ", MySqlDbType.VarChar, 50),
new MySqlParameter("@LXR", MySqlDbType.VarChar, 50),
new MySqlParameter("@YB", MySqlDbType.VarChar, 50),
new MySqlParameter("@QCJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@SRJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@FCJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@JCJE", MySqlDbType.Decimal, 15),
new MySqlParameter("@YE", MySqlDbType.Decimal, 15),
new MySqlParameter("@FCSL", MySqlDbType.Decimal, 15),
new MySqlParameter("@ML", MySqlDbType.Decimal, 15),
new MySqlParameter("@QCYE", MySqlDbType.Decimal, 15),
new MySqlParameter("@HM", MySqlDbType.Decimal, 18),
new MySqlParameter("@JB", MySqlDbType.VarChar, 50),
new MySqlParameter("@XXDWMC", MySqlDbType.VarChar, 60),
new MySqlParameter("@XXDZ", MySqlDbType.VarChar, 60),
new MySqlParameter("@KHH", MySqlDbType.VarChar, 50),
new MySqlParameter("@ZH", MySqlDbType.VarChar, 50),
new MySqlParameter("@SH", MySqlDbType.VarChar, 50),
new MySqlParameter("@SX", MySqlDbType.Decimal, 15),
new MySqlParameter("@SPBH", MySqlDbType.VarChar, 50),
new MySqlParameter("@LB", MySqlDbType.VarChar, 50),
new MySqlParameter("@JYFW", MySqlDbType.VarChar, 255),
new MySqlParameter("@SSBM", MySqlDbType.VarChar, 50),
new MySqlParameter("@DS", MySqlDbType.Decimal, 15),
new MySqlParameter("@RQ", MySqlDbType.DateTime),
new MySqlParameter("@RQ1", MySqlDbType.DateTime),
new MySqlParameter("@KHZT", MySqlDbType.VarChar, 50),
new MySqlParameter("@KHBM", MySqlDbType.VarChar, 50),
new MySqlParameter("@WXHM", MySqlDbType.VarChar, 50),
new MySqlParameter("@QQ", MySqlDbType.VarChar, 50),
new MySqlParameter("@DZYJ", MySqlDbType.VarChar, 50),
new MySqlParameter("@province_id", MySqlDbType.Int32, 11),
new MySqlParameter("@province_name", MySqlDbType.VarChar, 120),
new MySqlParameter("@city_id", MySqlDbType.Int32, 11),
new MySqlParameter("@city_name", MySqlDbType.VarChar, 120),
new MySqlParameter("@period_start", MySqlDbType.Decimal, 18),
new MySqlParameter("@period_start_date", MySqlDbType.DateTime),
new MySqlParameter("@Is_stop", MySqlDbType.Int16, 2),
new MySqlParameter("@ID", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.BM;
parameters[1].Value = model.DWMC;
parameters[2].Value = model.DH;
parameters[3].Value = model.ZTIDH;
parameters[4].Value = model.FAX;
parameters[5].Value = model.DZ;
parameters[6].Value = model.LXR;
parameters[7].Value = model.YB;
parameters[8].Value = model.QCJE;
parameters[9].Value = model.SRJE;
parameters[10].Value = model.FCJE;
parameters[11].Value = model.JCJE;
parameters[12].Value = model.YE;
parameters[13].Value = model.FCSL;
parameters[14].Value = model.ML;
parameters[15].Value = model.QCYE;
parameters[16].Value = model.HM;
parameters[17].Value = model.JB;
parameters[18].Value = model.XXDWMC;
parameters[19].Value = model.XXDZ;
parameters[20].Value = model.KHH;
parameters[21].Value = model.ZH;
parameters[22].Value = model.SH;
parameters[23].Value = model.SX;
parameters[24].Value = model.SPBH;
parameters[25].Value = model.LB;
parameters[26].Value = model.JYFW;
parameters[27].Value = model.SSBM;
parameters[28].Value = model.DS;
parameters[29].Value = model.RQ;
parameters[30].Value = model.RQ1;
parameters[31].Value = model.KHZT;
parameters[32].Value = model.KHBM;
parameters[33].Value = model.WXHM;
parameters[34].Value = model.QQ;
parameters[35].Value = model.DZYJ;
parameters[36].Value = model.province_id;
parameters[37].Value = model.province_name;
parameters[38].Value = model.city_id;
parameters[39].Value = model.city_name;
parameters[40].Value = model.period_start;
parameters[41].Value = model.period_start_date;
parameters[42].Value = model.Is_stop;
parameters[43].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
