/// <summary> /// 插入控制参数信息 /// </summary> /// <param name="controlParam"></param> /// <returns></returns> public int Insert(ControlParam controlParam) { string sql = "insert into com_controlargument(control_code,control_name,control_value,visible_flag,kind,controltype,controlvalue,oper_code,oper_date) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',TO_DATE('{8}','YYYY-MM-DD HH24:MI:SS'))"; sql = string.Format(sql, controlParam.ID, controlParam.Name, controlParam.ParamValue, controlParam.ParamState, controlParam.ParamKind, controlParam.ParamControlKind, controlParam.ParamControlValue, controlParam.Oper, controlParam.OperDate); return(this.ExecNoQuery(sql)); }
/// <summary> /// 更新控制参数信息 /// </summary> /// <param name="controlParam"></param> /// <returns></returns> public int update(ControlParam controlParam) { string sql = "update com_controlargument t set t.control_name='{1}',t.control_value='{2}',t.visible_flag='{3}',t.kind='{4}',t.controltype='{5}',t.controlvalue='{6}',t.oper_code='{7}',t.oper_date=TO_DATE('{8}','YYYY-MM-DD HH24:MI:SS') where t.control_code='{0}' "; sql = string.Format(sql, controlParam.ID, controlParam.Name, controlParam.ParamValue, controlParam.ParamState, controlParam.ParamKind, controlParam.ParamControlKind, controlParam.ParamControlValue, controlParam.Oper, controlParam.OperDate); return(this.ExecNoQuery(sql)); }
/// <summary> /// 为参数列表赋值 /// </summary> /// <param name="commonReader"></param> /// <returns></returns> private List <ControlParam> GetEnity(System.Data.IDataReader commonReader) { List <ControlParam> newList = new List <ControlParam>(); while (commonReader.Read()) { ControlParam controlParam = new ControlParam(); controlParam.ID = commonReader[0].ToString(); controlParam.Name = commonReader[1].ToString(); controlParam.ParamValue = commonReader[2].ToString(); controlParam.ParamState = commonReader[3].ToString(); controlParam.ParamKind = commonReader[4].ToString(); controlParam.ParamControlKind = commonReader[5].ToString(); controlParam.ParamControlValue = commonReader[6].ToString(); controlParam.Oper = commonReader[7].ToString(); controlParam.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(commonReader[8].ToString()); newList.Add(controlParam); } return(newList); }