/// <summary> /// 增加一条数据 /// </summary> public bool Add(FMS_Model.fkdw model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into fkdw("); strSql.Append("SKDW_MC,ZTIDH,ID,XJ,VIP)"); strSql.Append(" values ("); strSql.Append("@SKDW_MC,@ZTIDH,@ID,@XJ,@VIP)"); MySqlParameter[] parameters = { new MySqlParameter("@SKDW_MC", MySqlDbType.VarChar, 40), new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18), new MySqlParameter("@ID", MySqlDbType.Decimal, 18), new MySqlParameter("@XJ", MySqlDbType.VarChar, 30), new MySqlParameter("@VIP", MySqlDbType.VarChar, 30) }; parameters[0].Value = model.SKDW_MC; parameters[1].Value = model.ZTIDH; parameters[2].Value = model.ID; parameters[3].Value = model.XJ; parameters[4].Value = model.VIP; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FMS_Model.fkdw DataRowToModel(DataRow row) { FMS_Model.fkdw model = new FMS_Model.fkdw(); if (row != null) { if (row["SKDW_MC"] != null) { model.SKDW_MC = row["SKDW_MC"].ToString(); } if (row["ZTIDH"] != null && row["ZTIDH"].ToString() != "") { model.ZTIDH = decimal.Parse(row["ZTIDH"].ToString()); } if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = decimal.Parse(row["ID"].ToString()); } if (row["XJ"] != null) { model.XJ = row["XJ"].ToString(); } if (row["VIP"] != null) { model.VIP = row["VIP"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public FMS_Model.fkdw GetModel(string SKDW_MC, decimal ZTIDH, decimal ID, string XJ, string VIP) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SKDW_MC,ZTIDH,ID,XJ,VIP from fkdw "); strSql.Append(" where SKDW_MC=@SKDW_MC and ZTIDH=@ZTIDH and ID=@ID and XJ=@XJ and VIP=@VIP "); MySqlParameter[] parameters = { new MySqlParameter("@SKDW_MC", MySqlDbType.VarChar, 40), new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18), new MySqlParameter("@ID", MySqlDbType.Decimal, 18), new MySqlParameter("@XJ", MySqlDbType.VarChar, 30), new MySqlParameter("@VIP", MySqlDbType.VarChar, 30) }; parameters[0].Value = SKDW_MC; parameters[1].Value = ZTIDH; parameters[2].Value = ID; parameters[3].Value = XJ; parameters[4].Value = VIP; FMS_Model.fkdw model = new FMS_Model.fkdw(); 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.fkdw model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update fkdw set "); strSql.Append("SKDW_MC=@SKDW_MC,"); strSql.Append("ZTIDH=@ZTIDH,"); strSql.Append("ID=@ID,"); strSql.Append("XJ=@XJ,"); strSql.Append("VIP=@VIP"); strSql.Append(" where SKDW_MC=@SKDW_MC and ZTIDH=@ZTIDH and ID=@ID and XJ=@XJ and VIP=@VIP "); MySqlParameter[] parameters = { new MySqlParameter("@SKDW_MC", MySqlDbType.VarChar, 40), new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18), new MySqlParameter("@ID", MySqlDbType.Decimal, 18), new MySqlParameter("@XJ", MySqlDbType.VarChar, 30), new MySqlParameter("@VIP", MySqlDbType.VarChar, 30) }; parameters[0].Value = model.SKDW_MC; parameters[1].Value = model.ZTIDH; parameters[2].Value = model.ID; parameters[3].Value = model.XJ; parameters[4].Value = model.VIP; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(FMS_Model.fkdw model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FMS_Model.fkdw model) { return(dal.Add(model)); }