///<sumary> ///修改 ///</sumary> /// <param name="DATA0001">data0001对象</param> ///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns> public int Update(DATA0001 data0001) { #region 调用SQL存储过程进行修改 string sql = "sp_DATA0001_Update"; //===== SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), new SqlParameter("@RKEY", SqlDbType.Decimal, 9), new SqlParameter("@CURR_CODE", SqlDbType.VarChar, 5), new SqlParameter("@CURR_NAME", SqlDbType.VarChar, 20), new SqlParameter("@EXCH_RATE", SqlDbType.Decimal, 13), new SqlParameter("@TDATE", SqlDbType.DateTime, 8), new SqlParameter("@TREADONLY", SqlDbType.Decimal, 5), new SqlParameter("@BASE_TO_OTHER", SqlDbType.Decimal, 13), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9) }; parameters[0].Value = 1; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Value = data0001.RKEY; parameters[3].Value = data0001.CURR_CODE; parameters[4].Value = data0001.CURR_NAME; parameters[5].Value = data0001.EXCH_RATE; if (data0001.TDATE == DateTime.Parse("1900-1-1") || data0001.TDATE == DateTime.Parse("0001-1-1")) { parameters[6].Value = null; } else { parameters[6].Value = data0001.TDATE; } parameters[7].Value = data0001.TREADONLY; parameters[8].Value = data0001.BASE_TO_OTHER; parameters[9].Value = data0001.ACTIVE_FLAG; //=== #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";DATA0001,update successful"); } catch (Exception e) { log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); result = 2; } #endregion return(result); }
///<sumary> /// 通过主键获取数据对象 ///</sumary> /// <param name="RKEY">rkey</param> ///<returns>DATA0001对象</returns> public DATA0001 getDATA0001ByRKEY(decimal rkey) { #region SQL string sql = @"select top 1 isNull(rkey,0) as rkey , isNull(curr_code,'') as curr_code , isNull(curr_name,'') as curr_name , isNull(exch_rate,0) as exch_rate , isNull(tdate,'1900-1-1') as tdate , isNull(treadonly,0) as treadonly , isNull(base_to_other,0) as base_to_other , isNull(active_flag,0) as active_flag from DATA0001 with (nolock) where RKEY='{0}'" ; #endregion ///定义返回对象 DATA0001 data0001 = null; #region 数据库操作 try { data0001 = new DATA0001(); using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey))) { foreach (DataRow row in tb.Rows) { data0001.RKEY = decimal.Parse(row["RKEY"].ToString()); data0001.CURR_CODE = row["CURR_CODE"].ToString(); data0001.CURR_NAME = row["CURR_NAME"].ToString(); data0001.EXCH_RATE = decimal.Parse(row["EXCH_RATE"].ToString()); data0001.TDATE = DateTime.Parse(row["TDATE"].ToString()); data0001.TREADONLY = decimal.Parse(row["TREADONLY"].ToString()); data0001.BASE_TO_OTHER = decimal.Parse(row["BASE_TO_OTHER"].ToString()); data0001.ACTIVE_FLAG = decimal.Parse(row["ACTIVE_FLAG"].ToString()); } } } catch (Exception e) { //Console.WriteLine(e.Message); log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";get function:" + e.Message, e); } #endregion return(data0001); }
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 data0001) { // Validate input if (data0001 == null) { return; } data0001Dal.Update(cmd, conn, trans, data0001); }
public int Delete(DATA0001 data0001) { // Validate input if (data0001 == null) { return(0); } return(data0001Dal.Delete(data0001)); }
/// <summary> /// 向数据库中插入一条新记录。 /// </summary> /// <param name="DATA0001">data0001对象</param> /// <returns>新插入记录的编号</returns> public int Add(DATA0001 data0001) { // Validate input if (data0001 == null) { return(0); } return(data0001Dal.Add(data0001)); }
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 data0001) { // Validate input if (data0001 == null) { return(0); } return(data0001Dal.Add(cmd, conn, trans, data0001)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DATA0001 set "); strSql.Append("ID=@ID,"); strSql.Append("APPLYTIME=@APPLYTIME,"); strSql.Append("DEPT=@DEPT,"); strSql.Append("NAME=@NAME,"); strSql.Append("NUMBER=@NUMBER,"); strSql.Append("KIND=@KIND,"); strSql.Append("TYPE=@TYPE,"); strSql.Append("REACHTIME=@REACHTIME,"); strSql.Append("PROTYPE=@PROTYPE,"); strSql.Append("MAPNUMB=@MAPNUMB,"); strSql.Append("ATTACH=@ATTACH,"); strSql.Append("REASON=@REASON "); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.VarChar, 4), new SqlParameter("@ID", SqlDbType.VarChar, 4), new SqlParameter("@APPLYTIME", SqlDbType.VarChar, 4), new SqlParameter("@DEPT", SqlDbType.VarChar, 4), new SqlParameter("@NAME", SqlDbType.VarChar, 4), new SqlParameter("@NUMBER", SqlDbType.VarChar, 4), new SqlParameter("@KIND", SqlDbType.VarChar, 4), new SqlParameter("@TYPE", SqlDbType.VarChar, 4), new SqlParameter("@REACHTIME", SqlDbType.VarChar, 4), new SqlParameter("@PROTYPE", SqlDbType.VarChar, 4), new SqlParameter("@MAPNUMB", SqlDbType.VarChar, 4), new SqlParameter("@ATTACH", SqlDbType.VarChar, 4), new SqlParameter("@REASON", SqlDbType.VarChar, 4) }; parameters[0].Value = model.RKEY; parameters[0].Value = model.ID; parameters[0].Value = model.APPLYTIME; parameters[0].Value = model.DEPT; parameters[0].Value = model.NAME; parameters[0].Value = model.NUMBER; parameters[0].Value = model.KIND; parameters[0].Value = model.TYPE; parameters[0].Value = model.REACHTIME; parameters[0].Value = model.PROTYPE; parameters[0].Value = model.MAPNUMB; parameters[0].Value = model.ATTACH; parameters[0].Value = model.REASON; dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DATA0001 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DATA0001("); strSql.Append("ID,APPLYTIME,DEPT,NAME,NUMBER,KIND,TYPE,REACHTIME,PROTYPE.MAPNUMB,ATTACH,REASON)"); strSql.Append(" values ("); strSql.Append("@ID,@APPLYTIME,@DEPT,@NAME,@NUMBER,@KIND,@TYPE,@REACHTIME,@PROTYPE,@MAPNUMB,@ATTACH,@REASON)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 4), new SqlParameter("@APPLYTIME", SqlDbType.VarChar, 4), new SqlParameter("@DEPT", SqlDbType.VarChar, 4), new SqlParameter("@NAME", SqlDbType.VarChar, 4), new SqlParameter("@NUMBER", SqlDbType.VarChar, 4), new SqlParameter("@KIND", SqlDbType.VarChar, 4), new SqlParameter("@TYPE", SqlDbType.VarChar, 4), new SqlParameter("@REACHTIME", SqlDbType.VarChar, 4), new SqlParameter("@PROTYPE", SqlDbType.VarChar, 4), new SqlParameter("@MAPNUMB", SqlDbType.VarChar, 4), new SqlParameter("@ATTACH", SqlDbType.VarChar, 4), new SqlParameter("@REASON", SqlDbType.VarChar, 4) }; parameters[0].Value = model.ID; parameters[0].Value = model.APPLYTIME; parameters[0].Value = model.DEPT; parameters[0].Value = model.NAME; parameters[0].Value = model.NUMBER; parameters[0].Value = model.KIND; parameters[0].Value = model.TYPE; parameters[0].Value = model.REACHTIME; parameters[0].Value = model.PROTYPE; parameters[0].Value = model.MAPNUMB; parameters[0].Value = model.ATTACH; parameters[0].Value = model.REASON; object obj = dbHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DATA0001("); strSql.Append("ID,APPLYTIME,DEPT,NAME,NUMBER,KIND,TYPE,REACHTIME,PROTYPE.MAPNUMB,ATTACH,REASON)"); strSql.Append(" values ("); strSql.Append("@ID,@APPLYTIME,@DEPT,@NAME,@NUMBER,@KIND,@TYPE,@REACHTIME,@PROTYPE,@MAPNUMB,@ATTACH,@REASON)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 4), new SqlParameter("@APPLYTIME", SqlDbType.VarChar, 4), new SqlParameter("@DEPT", SqlDbType.VarChar, 4), new SqlParameter("@NAME", SqlDbType.VarChar, 4), new SqlParameter("@NUMBER", SqlDbType.VarChar, 4), new SqlParameter("@KIND", SqlDbType.VarChar, 4), new SqlParameter("@TYPE", SqlDbType.VarChar, 4), new SqlParameter("@REACHTIME", SqlDbType.VarChar, 4), new SqlParameter("@PROTYPE", SqlDbType.VarChar, 4), new SqlParameter("@MAPNUMB", SqlDbType.VarChar, 4), new SqlParameter("@ATTACH", SqlDbType.VarChar, 4), new SqlParameter("@REASON", SqlDbType.VarChar, 4) }; parameters[0].Value = model.ID; parameters[0].Value = model.APPLYTIME; parameters[0].Value = model.DEPT; parameters[0].Value = model.NAME; parameters[0].Value = model.NUMBER; parameters[0].Value = model.KIND; parameters[0].Value = model.TYPE; parameters[0].Value = model.REACHTIME; parameters[0].Value = model.PROTYPE; parameters[0].Value = model.MAPNUMB; parameters[0].Value = model.ATTACH; parameters[0].Value = model.REASON; return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters)); }
///<sumary> /// 删除 ///</sumary> /// <param name="data0001">对象</param> ///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns> public int Delete(DATA0001 data0001) { #region 调用SQL存储过程进行删除 string sql = "sp_DATA0001_Delete"; //========================= SqlParameter[] parameters = { new SqlParameter("@returnID", SqlDbType.Int), new SqlParameter("@userAD", SqlDbType.VarChar), new SqlParameter("@RKEY", SqlDbType.Decimal, 9) }; parameters[0].Value = 1; parameters[0].Direction = ParameterDirection.InputOutput; parameters[1].Value = this.userAD; parameters[2].Value = data0001.RKEY; //========================= #endregion #region 数据库操作 int result = 0; try { dbHelper.ExecuteCommandProc(sql, parameters); result = int.Parse(parameters[0].Value.ToString()); // log.Info("FID="+this.factoryID.ToString()+";userAD="+this.userAD+";DATA0001,delete successful"); } catch (Exception e) { result = 2; log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e); } #endregion return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public DATA0001 GetModel(int RKEY) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RKEY,SOURCE_CODE,ID_KEY,ANS_NAME from DATA0001 with(nolock) "); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Int, 4) }; parameters[0].Value = RKEY; DATA0001 model = new DATA0001(); DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString()); model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); model.APPLYTIME = DateTime.Parse(ds.Tables[0].Rows[0]["APPLYTIME"].ToString()); model.DEPT = ds.Tables[0].Rows[0]["DEPT"].ToString(); model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString(); model.NUMBER = ds.Tables[0].Rows[0]["NUMBER"].ToString(); model.KIND = ds.Tables[0].Rows[0]["KIND"].ToString(); model.TYPE = ds.Tables[0].Rows[0]["TYPE"].ToString(); model.REACHTIME = ds.Tables[0].Rows[0]["REACHTIME"].ToString(); model.PROTYPE = ds.Tables[0].Rows[0]["PROTYPE"].ToString(); model.MAPNUMB = ds.Tables[0].Rows[0]["MAPNUMB"].ToString(); model.ATTACH = ds.Tables[0].Rows[0]["ATTACH"].ToString(); model.REASON = ds.Tables[0].Rows[0]["REASON"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <DATA0001> DataTableToList(DataTable dt) { List <DATA0001> modelList = new List <DATA0001>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { DATA0001 model; for (int n = 0; n < rowsCount; n++) { model = new DATA0001(); if (dt.Rows[n]["RKEY"].ToString() != "") { model.RKEY = int.Parse(dt.Rows[n]["RKEY"].ToString()); } if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.APPLYTIME = DateTime.Parse(dt.Rows[0]["APPLYTIME"].ToString()); model.DEPT = dt.Rows[0]["DEPT"].ToString(); model.NAME = dt.Rows[0]["NAME"].ToString(); model.NUMBER = dt.Rows[0]["NUMBER"].ToString(); model.KIND = dt.Rows[0]["KIND"].ToString(); model.TYPE = dt.Rows[0]["TYPE"].ToString(); model.REACHTIME = dt.Rows[0]["REACHTIME"].ToString(); model.PROTYPE = dt.Rows[0]["PROTYPE"].ToString(); model.MAPNUMB = dt.Rows[0]["MAPNUMB"].ToString(); model.ATTACH = dt.Rows[0]["ATTACH"].ToString(); model.REASON = dt.Rows[0]["REASON"].ToString(); modelList.Add(model); } } return(modelList); }
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 data0001) { #region 创建SQL语法 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DATA0001("); strSql.Append("CURR_CODE,CURR_NAME,EXCH_RATE,TDATE,TREADONLY,BASE_TO_OTHER,ACTIVE_FLAG"); strSql.Append(" ) values ("); strSql.Append("@CURR_CODE,@CURR_NAME,@EXCH_RATE,@TDATE,@TREADONLY,@BASE_TO_OTHER,@ACTIVE_FLAG"); strSql.Append(");select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CURR_CODE", SqlDbType.VarChar, 5), new SqlParameter("@CURR_NAME", SqlDbType.VarChar, 20), new SqlParameter("@EXCH_RATE", SqlDbType.Decimal, 13), new SqlParameter("@TDATE", SqlDbType.DateTime, 8), new SqlParameter("@TREADONLY", SqlDbType.Decimal, 5), new SqlParameter("@BASE_TO_OTHER", SqlDbType.Decimal, 13), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9) }; parameters[0].Value = data0001.CURR_CODE; parameters[1].Value = data0001.CURR_NAME; parameters[2].Value = data0001.EXCH_RATE; if (data0001.TDATE == DateTime.Parse("1900-1-1") || data0001.TDATE == DateTime.Parse("0001-1-1")) { parameters[3].Value = null; } else { parameters[3].Value = data0001.TDATE; } parameters[4].Value = data0001.TREADONLY; parameters[5].Value = data0001.BASE_TO_OTHER; parameters[6].Value = data0001.ACTIVE_FLAG; #endregion #region 操作 if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.Connection = conn; cmd.CommandText = strSql.ToString(); cmd.Transaction = trans; cmd.CommandType = CommandType.Text;//cmdType; if (parameters != null) { foreach (SqlParameter parameter in parameters) { if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) && (parameter.Value == null)) { parameter.Value = DBNull.Value; } cmd.Parameters.Add(parameter); } } int indentity = 0; object obj = cmd.ExecuteScalar(); cmd.Parameters.Clear(); if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { indentity = 0; } else { indentity = int.Parse(obj.ToString()); } #endregion return(indentity); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(DATA0001 model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 model) { return(dal.Add(cmd, conn, trans, model)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 model) { dal.Update(cmd, conn, trans, model); }
///<sumary> /// 通过SQL语句获取数据对象 ///</sumary> /// <param name="sqlWhere">sqlWhere参数条件</param> ///<returns>IList<DATA0001>数据集合</returns> public IList <DATA0001> FindBySql(string sqlWhere) { #region SQL string sql = @"select isNull(rkey,0) as rkey , isNull(curr_code,'') as curr_code , isNull(curr_name,'') as curr_name , isNull(exch_rate,0) as exch_rate , isNull(tdate,'1900-1-1') as tdate , isNull(treadonly,0) as treadonly , isNull(base_to_other,0) as base_to_other , isNull(active_flag,0) as active_flag from DATA0001 with (nolock)" ; if (sqlWhere.Length > 0) { sql = sql + " where " + sqlWhere; } #endregion IList <DATA0001> resultList = new List <DATA0001>(); #region 操作 try { using (DataTable tb = dbHelper.GetDataSet(sql)) { foreach (DataRow row in tb.Rows) { DATA0001 data0001 = new DATA0001(); data0001.RKEY = decimal.Parse(row["RKEY"].ToString()); data0001.CURR_CODE = row["CURR_CODE"].ToString(); data0001.CURR_NAME = row["CURR_NAME"].ToString(); data0001.EXCH_RATE = decimal.Parse(row["EXCH_RATE"].ToString()); data0001.TDATE = DateTime.Parse(row["TDATE"].ToString()); data0001.TREADONLY = decimal.Parse(row["TREADONLY"].ToString()); data0001.BASE_TO_OTHER = decimal.Parse(row["BASE_TO_OTHER"].ToString()); data0001.ACTIVE_FLAG = decimal.Parse(row["ACTIVE_FLAG"].ToString()); resultList.Add(data0001); } } } catch (Exception e) { log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";FindBySql function:" + e.Message, e); throw e; } #endregion return(resultList); }
private void txt_save_Click(object sender, EventArgs e) { //引入实体 DATA0001 info = new DATA0001(); DATA0001BLL bll = new DATA0001BLL(db); #region 表不存在则创建 if (!db.TabExists("DATA0001")) { string sql = @"CREATE TABLE [dbo].[DATA0001]( [RKEY] [int] NOT NULL, [ID] [int] NOT NULL, [APPLYTIME] [datetime] NULL, [DEPT] [nchar](10) NULL, [NAME] [nchar](10) NULL, [NUMBER] [nchar](10) NULL, [KIND] [nchar](10) NULL, [TYPE] [nchar](10) NULL, [REACHTIME] [datetime] NULL, [PROTYPE] [nchar](10) NULL, [MAPNUMB] [nchar](10) NULL, [ATTACH] [nchar](10) NULL, [REASON] [nchar](10) NULL, CONSTRAINT [PK_DATA0001] PRIMARY KEY CLUSTERED ( [RKEY] ASC, [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; db.ExecuteNonQuery(sql); } #endregion #region 事务处理 using (SqlConnection conn = new SqlConnection(GlobalVal.ConnectionString(GlobalVal.UserInfo.FactoryID))) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted)) { SqlCommand cmd = new SqlCommand(); cmd.CommandTimeout = 360; try { if (bll.GetModelList("ID='" + ID + "' ").Count > 0) { int rkey = bll.GetModelList("ID='" + ID + "' ")[0].RKEY; info = bll.GetModel(rkey); //bll.Update(cmd, conn, trans, info); } else { info.ID = int.Parse(txt_ID.ToString()); info.APPLYTIME = DateTime.Parse(txt_APPLYTIME.ToString()); info.DEPT = txt_DEPT.ToString(); info.NAME = txt_NAME.ToString(); info.NUMBER = txt_NUMBER.ToString(); info.KIND = txt_KIND.ToString(); info.TYPE = txt_TYPE.ToString(); info.REACHTIME = txt_REACHTIME.ToString(); info.PROTYPE = txt_PROTYPE.ToString(); info.MAPNUMB = txt_MAPNUMB.ToString(); info.ATTACH = txt_ATTACH.ToString(); info.REASON = txt_REASON.ToString(); bll.Add(cmd, conn, trans, info); } trans.Commit(); MessageBox.Show("保存成功!"); } catch (Exception ee) { trans.Rollback();//异常回滚 log.PrintInfo(ee); MessageBox.Show("数据处理失败!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } #endregion } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DATA0001 model) { return(dal.Add(model)); }
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0001 data0001) { #region 创建语法 StringBuilder strSql = new StringBuilder(); strSql.Append("update DATA0001 set "); strSql.Append("CURR_CODE=@CURR_CODE,"); strSql.Append("CURR_NAME=@CURR_NAME,"); strSql.Append("EXCH_RATE=@EXCH_RATE,"); strSql.Append("TDATE=@TDATE,"); strSql.Append("TREADONLY=@TREADONLY,"); strSql.Append("BASE_TO_OTHER=@BASE_TO_OTHER,"); strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG"); strSql.Append(" where RKEY=@RKEY "); SqlParameter[] parameters = { new SqlParameter("@RKEY", SqlDbType.Decimal, 9), new SqlParameter("@CURR_CODE", SqlDbType.VarChar, 5), new SqlParameter("@CURR_NAME", SqlDbType.VarChar, 20), new SqlParameter("@EXCH_RATE", SqlDbType.Decimal, 13), new SqlParameter("@TDATE", SqlDbType.DateTime, 8), new SqlParameter("@TREADONLY", SqlDbType.Decimal, 5), new SqlParameter("@BASE_TO_OTHER", SqlDbType.Decimal, 13), new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9) }; parameters[0].Value = data0001.RKEY; parameters[1].Value = data0001.CURR_CODE; parameters[2].Value = data0001.CURR_NAME; parameters[3].Value = data0001.EXCH_RATE; if (data0001.TDATE == DateTime.Parse("1900-1-1") || data0001.TDATE == DateTime.Parse("0001-1-1")) { parameters[4].Value = null; } else { parameters[4].Value = data0001.TDATE; } parameters[5].Value = data0001.TREADONLY; parameters[6].Value = data0001.BASE_TO_OTHER; parameters[7].Value = data0001.ACTIVE_FLAG; #endregion #region 操作 if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.Connection = conn; cmd.CommandText = strSql.ToString(); cmd.Transaction = trans; cmd.CommandType = CommandType.Text;//cmdType; if (parameters != null) { foreach (SqlParameter parameter in parameters) { if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) && (parameter.Value == null)) { parameter.Value = DBNull.Value; } cmd.Parameters.Add(parameter); } } cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); #endregion }