///<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
}
