/// <summary> /// 增加一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQCZ ("); strSql.Append("CZ001,CZ002,CZ003,CZ004,CZ005,CZ006)"); strSql.Append(" VALUES ("); strSql.Append(" @CZ001,@CZ002,@CZ003,@CZ004,@CZ005,@CZ006);"); strSql.Append("SELECT SCOPE_IDENTITY();"); SqlParameter[] parameter = { new SqlParameter("@CZ001", SqlDbType.NVarChar), new SqlParameter("@CZ002", SqlDbType.NVarChar), new SqlParameter("@CZ003", SqlDbType.NVarChar), new SqlParameter("@CZ004", SqlDbType.Decimal), new SqlParameter("@CZ005", SqlDbType.Decimal), new SqlParameter("@CZ006", SqlDbType.NVarChar) }; parameter[0].Value = model.CZ001; parameter[1].Value = model.CZ002; parameter[2].Value = model.CZ003; parameter[3].Value = model.CZ004; parameter[4].Value = model.CZ005; parameter[5].Value = model.CZ006; int idx = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); return(idx); }
void assignMent( ) { modelCz = bll.GetModelCz(modelCz.IDX); lookUpEdit1.Text = textBox21.Text = modelCz.CZ001; if (!string.IsNullOrEmpty(modelCz.CZ003)) { dateTimePicker1.Value = dateTimePicker2.Value = DateTime.ParseExact(modelCz.CZ002 + modelCz.CZ003.Substring(2, 2), "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture); } textBox20.Text = modelCz.CZ004.ToString( ); textBox5.Text = modelCz.CZ005.ToString( ); yearMonth = modelCz.CZ002; modelDz.DZ004 = dateTimePicker1.Value.ToString("MMdd"); lookAss(modelDz.DZ004); }
/// <summary> /// 更改维护意见 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateWeiHu(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQCZ SET "); strSql.Append("CZ001=@CZ001,"); strSql.Append("CZ002=@CZ002,"); strSql.Append("CZ003=@CZ003,"); strSql.Append("CZ004=@CZ004,"); strSql.Append("CZ005=@CZ005,"); strSql.Append("CZ007=@CZ007,"); strSql.Append("CZ008=@CZ008"); strSql.Append(" WHERE CZ006=@CZ006"); SqlParameter[] parameter = { new SqlParameter("@CZ001", SqlDbType.NVarChar), new SqlParameter("@CZ002", SqlDbType.NVarChar), new SqlParameter("@CZ003", SqlDbType.NVarChar), new SqlParameter("@CZ004", SqlDbType.Decimal), new SqlParameter("@CZ005", SqlDbType.Decimal), new SqlParameter("@CZ006", SqlDbType.NVarChar), new SqlParameter("@CZ007", SqlDbType.NVarChar), new SqlParameter("@CZ008", SqlDbType.NVarChar) }; parameter[0].Value = model.CZ001; parameter[1].Value = model.CZ002; parameter[2].Value = model.CZ003; parameter[3].Value = model.CZ004; parameter[4].Value = model.CZ005; parameter[5].Value = model.CZ006; parameter[6].Value = model.CZ007; parameter[7].Value = model.CZ008; int rows = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条记录 /// </summary> /// <param name="idx"></param> /// <param name="model"></param> /// <returns></returns> public bool Delete(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model) { ArrayList SQLString = new ArrayList( ); StringBuilder strSql = new StringBuilder( ); strSql.AppendFormat("DELETE FROM R_PQCZ WHERE idx={0}", model.IDX); SQLString.Add(strSql.ToString( )); StringBuilder strD = new StringBuilder( ); strD.AppendFormat("SELECT COUNT(1) FROM R_PQDZ WHERE DZ001='{0}' AND DZ002='{1}' AND DZ003='{2}' AND DZ004='{3}'", model.CZ006, model.CZ001, model.CZ002, model.CZ003); if (SqlHelper.Exists(strSql.ToString( )) == true) { StringBuilder strSqlDz = new StringBuilder( ); strSqlDz.AppendFormat("DELETE FROM R_PQDZ WHERE DZ001='{0}' AND DZ002='{1}' AND DZ003='{2}' AND DZ004='{3}'", model.CZ006, model.CZ001, model.CZ002, model.CZ003); SQLString.Add(strSqlDz.ToString( )); } return(SqlHelper.ExecuteSqlTran(SQLString)); }
/// <summary> /// 获取数据集 /// </summary> /// <param name="row"></param> /// <returns></returns> public MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary GetDataRowCz(DataRow row) { MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model = new MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary( ); if (row != null) { if (row["idx"] != null && row["idx"].ToString( ) != "") { model.IDX = int.Parse(row["idx"].ToString( )); } if (row["CZ001"] != null && row["CZ001"].ToString( ) != "") { model.CZ001 = row["CZ001"].ToString( ); } if (row["CZ002"] != null && row["CZ002"].ToString( ) != "") { model.CZ002 = row["CZ002"].ToString( ); } if (row["CZ003"] != null && row["CZ003"].ToString( ) != "") { model.CZ003 = row["CZ003"].ToString( ); } if (row["CZ004"] != null && row["CZ004"].ToString( ) != "") { model.CZ004 = decimal.Parse(row["CZ004"].ToString( )); } if (row["CZ005"] != null && row["CZ005"].ToString( ) != "") { model.CZ005 = decimal.Parse(row["CZ005"].ToString( )); } if (row["CZ006"] != null && row["CZ006"].ToString( ) != "") { model.CZ006 = row["CZ006"].ToString( ); } } return(model); }
/// <summary> /// 删除一条记录 /// </summary> /// <param name="idx"></param> /// <param name="model"></param> /// <returns></returns> public bool Delete(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model) { return(dao.Delete(model)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model) { return(dao.Add(model)); }
/// <summary> /// 更改维护意见 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateWeiHu(MulaolaoLibrary.CheJianZhuRenKaoHeCzLibrary model) { return(dao.UpdateWeiHu(model)); }