/// <summary>
/// 获得数据列表
/// </summary>
public List <FOUNDERPCB_ANALYSIS> DataTableToList(DataTable dt)
{
List <FOUNDERPCB_ANALYSIS> modelList = new List <FOUNDERPCB_ANALYSIS>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
FOUNDERPCB_ANALYSIS model;
for (int n = 0; n < rowsCount; n++)
{
model = new FOUNDERPCB_ANALYSIS();
if (dt.Rows[n]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(dt.Rows[n]["RKEY"].ToString());
}
model.SOURCE_CODE = dt.Rows[n]["SOURCE_CODE"].ToString();
if (dt.Rows[n]["ID_KEY"].ToString() != "")
{
model.ID_KEY = int.Parse(dt.Rows[n]["ID_KEY"].ToString());
}
model.ANS_NAME = dt.Rows[n]["ANS_NAME"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FOUNDERPCB_ANALYSIS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FOUNDERPCB_ANALYSIS(");
strSql.Append("SOURCE_CODE,ID_KEY,ANS_NAME)");
strSql.Append(" values (");
strSql.Append("@SOURCE_CODE,@ID_KEY,@ANS_NAME)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SOURCE_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@ID_KEY", SqlDbType.Int, 4),
new SqlParameter("@ANS_NAME", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.SOURCE_CODE;
parameters[1].Value = model.ID_KEY;
parameters[2].Value = model.ANS_NAME;
object obj = dbHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FOUNDERPCB_ANALYSIS GetModel(int RKEY)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RKEY,SOURCE_CODE,ID_KEY,ANS_NAME from FOUNDERPCB_ANALYSIS with(nolock) ");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4)
};
parameters[0].Value = RKEY;
FOUNDERPCB_ANALYSIS model = new FOUNDERPCB_ANALYSIS();
DataSet ds = dbHelper.GetDataSet2(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RKEY"].ToString() != "")
{
model.RKEY = int.Parse(ds.Tables[0].Rows[0]["RKEY"].ToString());
}
model.SOURCE_CODE = ds.Tables[0].Rows[0]["SOURCE_CODE"].ToString();
if (ds.Tables[0].Rows[0]["ID_KEY"].ToString() != "")
{
model.ID_KEY = int.Parse(ds.Tables[0].Rows[0]["ID_KEY"].ToString());
}
model.ANS_NAME = ds.Tables[0].Rows[0]["ANS_NAME"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_ANALYSIS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FOUNDERPCB_ANALYSIS(");
strSql.Append("SOURCE_CODE,ID_KEY,ANS_NAME)");
strSql.Append(" values (");
strSql.Append("@SOURCE_CODE,@ID_KEY,@ANS_NAME)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SOURCE_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@ID_KEY", SqlDbType.Int, 4),
new SqlParameter("@ANS_NAME", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.SOURCE_CODE;
parameters[1].Value = model.ID_KEY;
parameters[2].Value = model.ANS_NAME;
return(dbHelper.ExecuteTranByID(cmd, conn, trans, strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_ANALYSIS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FOUNDERPCB_ANALYSIS set ");
strSql.Append("SOURCE_CODE=@SOURCE_CODE,");
strSql.Append("ID_KEY=@ID_KEY,");
strSql.Append("ANS_NAME=@ANS_NAME");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4),
new SqlParameter("@SOURCE_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@ID_KEY", SqlDbType.Int, 4),
new SqlParameter("@ANS_NAME", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.RKEY;
parameters[1].Value = model.SOURCE_CODE;
parameters[2].Value = model.ID_KEY;
parameters[3].Value = model.ANS_NAME;
dbHelper.ExecuteTranByNone(cmd, conn, trans, strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(FOUNDERPCB_ANALYSIS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FOUNDERPCB_ANALYSIS set ");
strSql.Append("SOURCE_CODE=@SOURCE_CODE,");
strSql.Append("ID_KEY=@ID_KEY,");
strSql.Append("ANS_NAME=@ANS_NAME");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Int, 4),
new SqlParameter("@SOURCE_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@ID_KEY", SqlDbType.Int, 4),
new SqlParameter("@ANS_NAME", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.RKEY;
parameters[1].Value = model.SOURCE_CODE;
parameters[2].Value = model.ID_KEY;
parameters[3].Value = model.ANS_NAME;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_ANALYSIS model)
{
dal.Update(cmd, conn, trans, model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(FOUNDERPCB_ANALYSIS model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, FOUNDERPCB_ANALYSIS model)
{
return(dal.Add(cmd, conn, trans, model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FOUNDERPCB_ANALYSIS model)
{
return(dal.Add(model));
}
private void Frm_Analysis_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(source_code))
{
MessageBox.Show("参数未设置");
this.Close();
return;
}
if (source_code == "9107")
{
this.Text = "小包分析代码设置";
}
else if (source_code == "9108")
{
this.Text = "外箱分析代码设置";
}
#region 分析代码名称获取
FOUNDERPCB_ANALYSIS anainfo = new FOUNDERPCB_ANALYSIS();
FOUNDERPCB_ANALYSISBLL anabll = new FOUNDERPCB_ANALYSISBLL(db);
if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1").Count > 0)
{
int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1")[0].RKEY;
anainfo = anabll.GetModel(rkey);
if (anainfo.ANS_NAME.Trim().Length > 0)
{
textBox1.Text = anainfo.ANS_NAME.Trim();
}
}
if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2").Count > 0)
{
int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2")[0].RKEY;
anainfo = anabll.GetModel(rkey);
if (anainfo.ANS_NAME.Trim().Length > 0)
{
textBox2.Text = anainfo.ANS_NAME.Trim();
}
}
if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3").Count > 0)
{
int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3")[0].RKEY;
anainfo = anabll.GetModel(rkey);
if (anainfo.ANS_NAME.Trim().Length > 0)
{
textBox3.Text = anainfo.ANS_NAME.Trim();
}
}
if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4").Count > 0)
{
int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4")[0].RKEY;
anainfo = anabll.GetModel(rkey);
if (anainfo.ANS_NAME.Trim().Length > 0)
{
textBox4.Text = anainfo.ANS_NAME.Trim();
}
}
if (anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5").Count > 0)
{
int rkey = anabll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5")[0].RKEY;
anainfo = anabll.GetModel(rkey);
if (anainfo.ANS_NAME.Trim().Length > 0)
{
textBox5.Text = anainfo.ANS_NAME.Trim();
}
}
#endregion
}
private void button1_Click(object sender, EventArgs e)
{
FOUNDERPCB_ANALYSIS info = new FOUNDERPCB_ANALYSIS();
FOUNDERPCB_ANALYSISBLL bll = new FOUNDERPCB_ANALYSISBLL(db);
#region 表不存在则创建
if (!db.TabExists("FOUNDERPCB_ANALYSIS"))
{
string sql = @"CREATE TABLE [dbo].[FOUNDERPCB_ANALYSIS](
[RKEY] [int] IDENTITY(1,1) NOT NULL,
[SOURCE_CODE] [varchar](20) NULL,
[ID_KEY] [int] NULL,
[ANS_NAME] [varchar](50) NULL,
CONSTRAINT [PK_FOUNDERPCB_ANALYSIS] PRIMARY KEY CLUSTERED
(
[RKEY] 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
{
#region 分析代码1
if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1").Count > 0)
{
int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=1")[0].RKEY;
info = bll.GetModel(rkey);
info.ANS_NAME = textBox1.Text.Trim();
bll.Update(cmd, conn, trans, info);
}
else
{
info.SOURCE_CODE = source_code;
info.ID_KEY = 1;
info.ANS_NAME = textBox1.Text.Trim();
bll.Add(cmd, conn, trans, info);
}
#endregion
#region 分析代码2
if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2").Count > 0)
{
int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=2")[0].RKEY;
info = bll.GetModel(rkey);
info.ANS_NAME = textBox2.Text.Trim();
bll.Update(cmd, conn, trans, info);
}
else
{
info.SOURCE_CODE = source_code;
info.ID_KEY = 2;
info.ANS_NAME = textBox2.Text.Trim();
bll.Add(cmd, conn, trans, info);
}
#endregion
#region 分析代码3
if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3").Count > 0)
{
int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=3")[0].RKEY;
info = bll.GetModel(rkey);
info.ANS_NAME = textBox3.Text.Trim();
bll.Update(cmd, conn, trans, info);
}
else
{
info.SOURCE_CODE = source_code;
info.ID_KEY = 3;
info.ANS_NAME = textBox3.Text.Trim();
bll.Add(cmd, conn, trans, info);
}
#endregion
#region 分析代码4
if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4").Count > 0)
{
int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=4")[0].RKEY;
info = bll.GetModel(rkey);
info.ANS_NAME = textBox4.Text.Trim();
bll.Update(cmd, conn, trans, info);
}
else
{
info.SOURCE_CODE = source_code;
info.ID_KEY = 4;
info.ANS_NAME = textBox4.Text.Trim();
bll.Add(cmd, conn, trans, info);
}
#endregion
#region 分析代码5
if (bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5").Count > 0)
{
int rkey = bll.GetModelList("SOURCE_CODE='" + source_code + "' AND ID_KEY=5")[0].RKEY;
info = bll.GetModel(rkey);
info.ANS_NAME = textBox5.Text.Trim();
bll.Update(cmd, conn, trans, info);
}
else
{
info.SOURCE_CODE = source_code;
info.ID_KEY = 5;
info.ANS_NAME = textBox5.Text.Trim();
bll.Add(cmd, conn, trans, info);
}
#endregion
trans.Commit();
MessageBox.Show("保存成功！");
}
catch (Exception ee)
{
trans.Rollback();//异常回滚
log.PrintInfo(ee);
MessageBox.Show("数据处理失败！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
}
#endregion
}
