private void dgvParamList_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null && ParamValue == dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()) { return; } if (e.ColumnIndex == 3 && !string.IsNullOrEmpty(ParamValue) && (dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == null || dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString().Trim().Equals(""))) { cmn.Show("当前值不能修改为空!"); dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = ParamValue; return; } if (!cmn.Confirm("修改当前行的值?")) { dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = ParamValue; } else { SysParameterModel mParamter = new SysParameterModel(); mParamter.ParamId = int.Parse(dgvParamList.Rows[e.RowIndex].Cells["ParamId"].Value.ToString()); mParamter.Value1 = dgvParamList.Rows[e.RowIndex].Cells["Value1"].Value.ToString().ToUpper(); mParamter.Value2 = dgvParamList.Rows[e.RowIndex].Cells["Value2"].Value == null ? "" : dgvParamList.Rows[e.RowIndex].Cells["Value2"].Value.ToString().ToUpper(); mParamter.Value3 = dgvParamList.Rows[e.RowIndex].Cells["Value3"].Value == null ? "" : dgvParamList.Rows[e.RowIndex].Cells["Value3"].Value.ToString().ToUpper(); oCtrl.Reset(); oCtrl.Add(MCtrl.SetValue1); oCtrl.Add(MCtrl.SetValue2); oCtrl.Add(MCtrl.SetValue3); bParam.UpdateParameter(mParamter, oCtrl); } }
public List <SysParameterModel> GetSysParameter(SysParameterModel mParameter, ObjectControls oCtrl) { string sql = "SELECT A.PARAM_ID,A.PARAM_NO,A.PARAM_NAME,A.PARAM_DESC,A.VALUE1,A.VALUE2,A.VALUE3 FROM SYS_PARAMETER A WHERE 1=1"; oCtrl.Helper(oCtrl.Exsit(MCtrl.ByParameterId) && oCtrl.Append(ref sql, " AND A.PARAM_ID=" + mParameter.ParamId)); oCtrl.Helper(oCtrl.Exsit(MCtrl.ByParameterNo) && oCtrl.Append(ref sql, " AND A.PARAM_NO=" + mParameter.ParamNo)); oCtrl.Helper(oCtrl.Exsit(MCtrl.ByParameterName) && oCtrl.Append(ref sql, " AND A.PARAM_NAME=" + mParameter.ParamName)); sdr = ExecuteReader(sql); List <SysParameterModel> listParameter = new List <SysParameterModel>(); using (sdr) { while (sdr.Read()) { SysParameterModel mSysParameterInfo = new SysParameterModel(); mSysParameterInfo.ParamId = ToInt32(sdr["PARAM_ID"]); mSysParameterInfo.ParamNo = ToString(sdr["PARAM_NO"]); mSysParameterInfo.ParamName = ToString(sdr["PARAM_NAME"]); mSysParameterInfo.ParamDesc = ToString(sdr["PARAM_DESC"]); mSysParameterInfo.Value1 = ToString(sdr["VALUE1"]); mSysParameterInfo.Value2 = ToString(sdr["VALUE2"]); mSysParameterInfo.Value3 = ToString(sdr["VALUE3"]); listParameter.Add(mSysParameterInfo); } } return(listParameter); }
public int UpdateParameter(SysParameterModel mParameter, ObjectControls oCtrl) { string sql = "UPDATE SYS_PARAMETER SET PARAM_NO=PARAM_NO "; oCtrl.Helper(oCtrl.Exsit(MCtrl.SetValue1) && oCtrl.Append(ref sql, ",VALUE1=" + SQL(mParameter.Value1))); oCtrl.Helper(oCtrl.Exsit(MCtrl.SetValue2) && oCtrl.Append(ref sql, ",VALUE2=" + SQL(mParameter.Value2))); oCtrl.Helper(oCtrl.Exsit(MCtrl.SetValue3) && oCtrl.Append(ref sql, ",VALUE3=" + SQL(mParameter.Value3))); sql += " WHERE PARAM_ID=" + mParameter.ParamId; return(ExcuteNonQuery(sql)); }
public int UpdateParameter(SysParameterModel mParameter, ObjectControls oCtrl) { return(dSysParameter.UpdateParameter(mParameter, oCtrl)); }
//public List<SysParameterModel> GetParameterList(SysParameterModel mParameter) //{ // var query = dc.SYS_PARAMETER.Where(c => c.PARAM_NO == mParameter.ParamNo); // List<SysParameterModel> listParameter = new List<SysParameterModel>(); // Log.WriteLog(dc, query, AbBaseBll.IsWriteSql); // foreach (SYS_PARAMETER sp in query) // { // SysParameterModel mSysParameterNew = new SysParameterModel(); // mSysParameterNew.ParamId = sp.PARAM_ID; // mSysParameterNew.ParamName = sp.PARAM_NAME; // mSysParameterNew.ParamNo = sp.PARAM_NO; // mSysParameterNew.Value1 = sp.VALUE1; // mSysParameterNew.Value2 = sp.VALUE2; // mSysParameterNew.Value3 = sp.VALUE3; // listParameter.Add(mSysParameterNew); // } // return listParameter; //} /// <summary> /// 获取系统设置参数表 /// </summary> /// <param name="mParameter"></param> /// <param name="oCtrl"></param> /// <returns></returns> public List <SysParameterModel> GetSysParameter(SysParameterModel mParameter, ObjectControls oCtrl) { return(dSysParameter.GetSysParameter(mParameter, oCtrl)); }