void queryContent( ) { _model = _bll.GetModel(_model.BC001); if (_model == null) { return; } textBox1.Text = _model.BC002; textBox2.Text = _model.BC003; textBox3.Text = _model.BC004; textBox4.Text = _model.BC005.ToString( ); comboBox1.Text = _model.BC006; comboBox2.Text = _model.BC007; comboBox3.Text = _model.BC008; comboBox4.Text = _model.BC009; if (_model.BC010 > DateTime.MinValue && _model.BC010 < DateTime.MaxValue) { dateTimePicker1.Value = _model.BC010; } if (_model.BC011 > DateTime.MinValue && _model.BC011 < DateTime.MaxValue) { dateTimePicker2.Value = _model.BC011; } if (_model.BC012 > DateTime.MinValue && _model.BC012 < DateTime.MaxValue) { dateTimePicker3.Value = _model.BC012; } if (_model.BC013 > DateTime.MinValue && _model.BC013 < DateTime.MaxValue) { dateTimePicker4.Value = _model.BC013; } textBox5.Text = _model.BC014.ToString( ); textBox6.Text = _model.BC041; refre( ); }
public string UpdateOfAll(MulaolaoLibrary.QualityTestingLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQBC SET"); strSql.AppendFormat("BC015='{0}',", _model.BC015); strSql.AppendFormat("BC042='{0}'", _model.BC042); strSql.AppendFormat(" WHERE BC001='{0}' AND BC043='{1}'", _model.BC001, _model.BC043); return(strSql.ToString( )); }
public string Add(MulaolaoLibrary.QualityTestingLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("INSERT INTO R_PQBC ("); strSql.Append("BC001,BC043,BC015,BC042)"); strSql.Append(" VALUES ("); strSql.AppendFormat("'{0}','{1}','{2}','{3}')", _model.BC001, _model.BC043, _model.BC015, _model.BC042); return(strSql.ToString( )); }
protected override void select( ) { base.select( ); _model = new MulaolaoLibrary.QualityTestingLibrary( ); SelectAll.QualityTestingALL query = new SelectAll.QualityTestingALL( ); query.StartPosition = FormStartPosition.CenterScreen; query.PassDataBetweenForm += new SelectAll.QualityTestingALL.PassDataBetweenFormHandler(query_PassDataBetWeenForm); query.ShowDialog( ); if (_model.BC001 != null) { autoQuery( ); } }
public bool ExistsOf(MulaolaoLibrary.QualityTestingLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT COUNT(1) FROM R_PQBC"); strSql.Append(" WHERE BC001=@BC001 AND BC003=@BC003 AND BC015=@BC015 AND BC042=@BC042"); SqlParameter[] parameter = { new SqlParameter("@BC001", SqlDbType.NVarChar, 20), new SqlParameter("@BC003", SqlDbType.NVarChar, 20), new SqlParameter("@BC015", SqlDbType.NVarChar, 20), new SqlParameter("@BC042", SqlDbType.NVarChar, 20) }; parameter[0].Value = _model.BC001; parameter[1].Value = _model.BC003; parameter[2].Value = _model.BC015; parameter[3].Value = _model.BC042; return(SqlHelper.Exists(strSql.ToString( ), parameter)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool SaveOfUpdate(MulaolaoLibrary.QualityTestingLibrary _model) { return(_dao.SaveOfUpdate(_model)); }
/// <summary> /// 得到数据集 /// </summary> /// <param name="row"></param> /// <returns></returns> public MulaolaoLibrary.QualityTestingLibrary GetDataRow(DataRow row) { MulaolaoLibrary.QualityTestingLibrary _model = new MulaolaoLibrary.QualityTestingLibrary( ); if (row != null) { if (row["BC001"] != null && row["BC001"].ToString( ) != "") { _model.BC001 = row["BC001"].ToString( ); } if (row["BC002"] != null && row["BC002"].ToString( ) != "") { _model.BC002 = row["BC002"].ToString( ); } if (row["BC003"] != null && row["BC003"].ToString( ) != "") { _model.BC003 = row["BC003"].ToString( ); } if (row["BC004"] != null && row["BC004"].ToString( ) != "") { _model.BC004 = row["BC004"].ToString( ); } if (row["BC006"] != null && row["BC006"].ToString( ) != "") { _model.BC006 = row["BC006"].ToString( ); } if (row["BC007"] != null && row["BC007"].ToString( ) != "") { _model.BC007 = row["BC007"].ToString( ); } if (row["BC008"] != null && row["BC008"].ToString( ) != "") { _model.BC008 = row["BC008"].ToString( ); } if (row["BC009"] != null && row["BC009"].ToString( ) != "") { _model.BC009 = row["BC009"].ToString( ); } if (row["BC010"] != null && row["BC010"].ToString( ) != "") { _model.BC010 = DateTime.Parse(row["BC010"].ToString( )); } if (row["BC011"] != null && row["BC011"].ToString( ) != "") { _model.BC011 = DateTime.Parse(row["BC011"].ToString( )); } if (row["BC012"] != null && row["BC012"].ToString( ) != "") { _model.BC012 = DateTime.Parse(row["BC012"].ToString( )); } if (row["BC013"] != null && row["BC013"].ToString( ) != "") { _model.BC013 = DateTime.Parse(row["BC013"].ToString( )); } if (row["BC014"] != null && row["BC014"].ToString( ) != "") { _model.BC014 = int.Parse(row["BC014"].ToString( )); } if (row["BC040"] != null && row["BC040"].ToString( ) != "") { _model.BC040 = row["BC040"].ToString( ); } if (row["BC041"] != null && row["BC041"].ToString( ) != "") { _model.BC041 = row["BC041"].ToString( ); } } return(_model); }
/// <summary> /// 获取数据列表 /// </summary> /// <param name="oddNum"></param> /// <returns></returns> public DataTable GetDataTableOf(string oddNum, string num) { MulaolaoLibrary.QualityTestingLibrary _model = new MulaolaoLibrary.QualityTestingLibrary( ); _model.BC001 = oddNum; _model.BC003 = num; string maxNum = ""; List <int> strList = new List <int>( ); ArrayList SQLString = new ArrayList( ); DataTable da = GetDataTableOfLj(num); if (da != null && da.Rows.Count > 0) { DataTable de = SqlHelper.ExecuteDataTable("SELECT BC001,BC043,BC003,BC015,BC042 FROM R_PQBC WHERE BC001='" + _model.BC001 + "'"); for (int i = 0; i < da.Rows.Count; i++) { _model.BC015 = da.Rows[i]["DS03"].ToString( ); _model.BC042 = da.Rows[i]["DS04"].ToString( ); if (de != null && de.Rows.Count > 0) { if (de.Select("BC003='" + _model.BC003 + "' AND BC015='" + _model.BC015 + "' AND BC042='" + _model.BC042 + "'").Length > 0) { _model.BC043 = de.Select("BC003='" + _model.BC003 + "' AND BC015='" + _model.BC015 + "' AND BC042='" + _model.BC042 + "'") [0] ["BC043"].ToString( ); SQLString.Add(UpdateOfAll(_model)); } else { maxNum = de.Compute("MAX(BC043)", null).ToString( ); if (!string.IsNullOrEmpty(maxNum)) { if (Convert.ToInt32(maxNum) < 9) { _model.BC043 = "00" + (Convert.ToInt32(maxNum) + 1); } else if (Convert.ToInt32(maxNum) >= 9 && Convert.ToInt32(maxNum) < 99) { _model.BC043 = "0" + (Convert.ToInt32(maxNum) + 1); } else { _model.BC043 = (Convert.ToInt32(maxNum) + 1).ToString( ); } } else { if (strList.Count > 0) { maxNum = strList.Max( ).ToString( ); if (Convert.ToInt32(maxNum) < 9) { _model.BC043 = "00" + (Convert.ToInt32(maxNum) + 1); } else if (Convert.ToInt32(maxNum) >= 9 && Convert.ToInt32(maxNum) < 99) { _model.BC043 = "0" + (Convert.ToInt32(maxNum) + 1); } else { _model.BC043 = (Convert.ToInt32(maxNum) + 1).ToString( ); } } else { _model.BC043 = "001"; } strList.Add(Convert.ToInt32(_model.BC043)); } SQLString.Add(Add(_model)); } } else { if (strList.Count > 0) { maxNum = strList.Max( ).ToString( ); if (Convert.ToInt32(maxNum) < 9) { _model.BC043 = "00" + (Convert.ToInt32(maxNum) + 1); } else if (Convert.ToInt32(maxNum) >= 9 && Convert.ToInt32(maxNum) < 99) { _model.BC043 = "0" + (Convert.ToInt32(maxNum) + 1); } else { _model.BC043 = (Convert.ToInt32(maxNum) + 1).ToString( ); } } else { _model.BC043 = "001"; } strList.Add(Convert.ToInt32(_model.BC043)); SQLString.Add(Add(_model)); } } } SqlHelper.ExecuteSqlTran(SQLString); StringBuilder strSql = new StringBuilder( ); strSql.Append("SELECT * FROM R_PQBC"); strSql.Append(" WHERE BC001=@BC001"); SqlParameter[] parameter = { new SqlParameter("@BC001", SqlDbType.NVarChar) }; parameter[0].Value = oddNum; return(SqlHelper.ExecuteDataTable(strSql.ToString( ), parameter)); }
/// <summary> /// 保存数据 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool SaveOfUpdate(MulaolaoLibrary.QualityTestingLibrary _model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("UPDATE R_PQBC SET "); strSql.Append("BC002=@BC002,"); strSql.Append("BC004=@BC004,"); strSql.Append("BC006=@BC006,"); strSql.Append("BC007=@BC007,"); strSql.Append("BC008=@BC008,"); strSql.Append("BC009=@BC009,"); strSql.Append("BC010=@BC010,"); strSql.Append("BC011=@BC011,"); strSql.Append("BC012=@BC012,"); strSql.Append("BC013=@BC013,"); strSql.Append("BC014=@BC014,"); strSql.Append("BC040=@BC040,"); strSql.Append("BC041=@BC041"); strSql.Append(" WHERE BC001=@BC001"); SqlParameter[] parameter = { new SqlParameter("@BC001", SqlDbType.NVarChar, 20), new SqlParameter("@BC002", SqlDbType.NVarChar, 20), new SqlParameter("@BC004", SqlDbType.NVarChar, 20), new SqlParameter("@BC006", SqlDbType.NVarChar, 20), new SqlParameter("@BC007", SqlDbType.NVarChar, 20), new SqlParameter("@BC008", SqlDbType.NVarChar, 20), new SqlParameter("@BC009", SqlDbType.NVarChar, 20), new SqlParameter("@BC010", SqlDbType.Date), new SqlParameter("@BC011", SqlDbType.Date), new SqlParameter("@BC012", SqlDbType.Date), new SqlParameter("@BC013", SqlDbType.Date), new SqlParameter("@BC014", SqlDbType.Int), new SqlParameter("@BC040", SqlDbType.NVarChar, 2000), new SqlParameter("@BC041", SqlDbType.NVarChar, 2000) }; parameter[0].Value = _model.BC001; parameter[1].Value = _model.BC002; parameter[2].Value = _model.BC004; parameter[3].Value = _model.BC006; parameter[4].Value = _model.BC007; parameter[5].Value = _model.BC008; parameter[6].Value = _model.BC009; parameter[7].Value = _model.BC010; parameter[8].Value = _model.BC011; parameter[9].Value = _model.BC012; parameter[10].Value = _model.BC013; parameter[11].Value = _model.BC014; parameter[12].Value = _model.BC040; parameter[13].Value = _model.BC041; int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameter); if (row > 0) { return(true); } else { return(false); } }