/// <summary>
/// 向数据库中插入一条新记录。
/// </summary>
/// <param name="DATA0002">data0002对象</param>
/// <returns>新插入记录的编号</returns>
public int Add(DATA0002 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DATA0002(");
strSql.Append("UNIT_CODE,UNIT_NAME,PROD,PURCH,STOCK,QUOTE,SELL,UNIT_BASE,DERIVED,INT_CHECK,EXPRESSION,MIN_UNIT_VALUE,MAX_UNIT_VALUE,UNIT_TYPE,POT_OUTER_LAYER,POT_INNER_LAYER,ACTIVE_FLAG,ECN_FLAG)");
strSql.Append(" values (");
strSql.Append("@UNIT_CODE,@UNIT_NAME,@PROD,@PURCH,@STOCK,@QUOTE,@SELL,@UNIT_BASE,@DERIVED,@INT_CHECK,@EXPRESSION,@MIN_UNIT_VALUE,@MAX_UNIT_VALUE,@UNIT_TYPE,@POT_OUTER_LAYER,@POT_INNER_LAYER,@ACTIVE_FLAG,@ECN_FLAG)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 5),
new SqlParameter("@UNIT_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@PROD", SqlDbType.Char, 1),
new SqlParameter("@PURCH", SqlDbType.Char, 1),
new SqlParameter("@STOCK", SqlDbType.Char, 1),
new SqlParameter("@QUOTE", SqlDbType.Char, 1),
new SqlParameter("@SELL", SqlDbType.Char, 1),
new SqlParameter("@UNIT_BASE", SqlDbType.Char, 1),
new SqlParameter("@DERIVED", SqlDbType.Char, 1),
new SqlParameter("@INT_CHECK", SqlDbType.Char, 1),
new SqlParameter("@EXPRESSION", SqlDbType.VarChar, 50),
new SqlParameter("@MIN_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@MAX_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@UNIT_TYPE", SqlDbType.Char, 1),
new SqlParameter("@POT_OUTER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@POT_INNER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9),
new SqlParameter("@ECN_FLAG", SqlDbType.VarChar, 1)
};
parameters[0].Value = model.UNIT_CODE;
parameters[1].Value = model.UNIT_NAME;
parameters[2].Value = model.PROD;
parameters[3].Value = model.PURCH;
parameters[4].Value = model.STOCK;
parameters[5].Value = model.QUOTE;
parameters[6].Value = model.SELL;
parameters[7].Value = model.UNIT_BASE;
parameters[8].Value = model.DERIVED;
parameters[9].Value = model.INT_CHECK;
parameters[10].Value = model.EXPRESSION;
parameters[11].Value = model.MIN_UNIT_VALUE;
parameters[12].Value = model.MAX_UNIT_VALUE;
parameters[13].Value = model.UNIT_TYPE;
parameters[14].Value = model.POT_OUTER_LAYER;
parameters[15].Value = model.POT_INNER_LAYER;
parameters[16].Value = model.ACTIVE_FLAG;
parameters[17].Value = model.ECN_FLAG;
object obj = dbHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex >= 0)
{
d02info = d02list[e.RowIndex];
this.DialogResult = DialogResult.OK;
}
}
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0002 data0002)
{
// Validate input
if (data0002 == null)
{
return(0);
}
return(data0002Dal.Add(cmd, conn, trans, data0002));
}
/// <summary>
/// 向数据库中插入一条新记录。
/// </summary>
/// <param name="DATA0002">data0002对象</param>
/// <returns>新插入记录的编号</returns>
public int Add(DATA0002 data0002)
{
// Validate input
if (data0002 == null)
{
return(0);
}
return(data0002Dal.Add(data0002));
}
public int Delete(DATA0002 data0002)
{
// Validate input
if (data0002 == null)
{
return(0);
}
return(data0002Dal.Delete(data0002));
}
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0002 data0002)
{
// Validate input
if (data0002 == null)
{
return;
}
data0002Dal.Update(cmd, conn, trans, data0002);
}
///<sumary>
/// 删除
///</sumary>
/// <param name="data0002">对象</param>
///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns>
public int Delete(DATA0002 data0002)
{
#region 调用SQL存储过程进行删除
string sql = "sp_DATA0002_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 = data0002.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 + ";DATA0002,delete successful");
}
catch (Exception e)
{
result = 2;
log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";" + e.Message, e);
}
#endregion
return(result);
}
///<sumary>
/// 通过SQL语句获取数据对象
///</sumary>
/// <param name="sqlWhere">sqlWhere参数条件</param>
///<returns>IList<DATA0002>数据集合</returns>
public IList <DATA0002> FindBySql(string sqlWhere)
{
#region SQL
string sql = @"select
isNull(rkey,0) as rkey
,
isNull(unit_code,'') as unit_code
,
isNull(unit_name,'') as unit_name
,
isNull(prod,'') as prod
,
isNull(purch,'') as purch
,
isNull(stock,'') as stock
,
isNull(quote,'') as quote
,
isNull(sell,'') as sell
,
isNull(unit_base,'') as unit_base
,
isNull(derived,'') as derived
,
isNull(int_check,'') as int_check
,
isNull(expression,'') as expression
,
isNull(min_unit_value,0) as min_unit_value
,
isNull(max_unit_value,0) as max_unit_value
,
isNull(unit_type,'') as unit_type
,
isNull(pot_outer_layer,0) as pot_outer_layer
,
isNull(pot_inner_layer,0) as pot_inner_layer
,
isNull(active_flag,0) as active_flag
,
isNull(ecn_flag,'') as ecn_flag
from DATA0002 with (nolock)" ;
if (sqlWhere.Length > 0)
{
sql = sql + " where " + sqlWhere;
}
#endregion
IList <DATA0002> resultList = new List <DATA0002>();
#region 操作
try
{
using (DataTable tb = dbHelper.GetDataSet(sql))
{
foreach (DataRow row in tb.Rows)
{
DATA0002 data0002 = new DATA0002();
data0002.RKEY = decimal.Parse(row["RKEY"].ToString());
data0002.UNIT_CODE = row["UNIT_CODE"].ToString();
data0002.UNIT_NAME = row["UNIT_NAME"].ToString();
data0002.PROD = row["PROD"].ToString();
data0002.PURCH = row["PURCH"].ToString();
data0002.STOCK = row["STOCK"].ToString();
data0002.QUOTE = row["QUOTE"].ToString();
data0002.SELL = row["SELL"].ToString();
data0002.UNIT_BASE = row["UNIT_BASE"].ToString();
data0002.DERIVED = row["DERIVED"].ToString();
data0002.INT_CHECK = row["INT_CHECK"].ToString();
data0002.EXPRESSION = row["EXPRESSION"].ToString();
data0002.MIN_UNIT_VALUE = decimal.Parse(row["MIN_UNIT_VALUE"].ToString());
data0002.MAX_UNIT_VALUE = decimal.Parse(row["MAX_UNIT_VALUE"].ToString());
data0002.UNIT_TYPE = row["UNIT_TYPE"].ToString();
data0002.POT_OUTER_LAYER = decimal.Parse(row["POT_OUTER_LAYER"].ToString());
data0002.POT_INNER_LAYER = decimal.Parse(row["POT_INNER_LAYER"].ToString());
data0002.ACTIVE_FLAG = decimal.Parse(row["ACTIVE_FLAG"].ToString());
data0002.ECN_FLAG = row["ECN_FLAG"].ToString();
resultList.Add(data0002);
}
}
}
catch (Exception e)
{
log.Info("FID=" + this.factoryID.ToString() + ";userAD=" + this.userAD + ";FindBySql function:" + e.Message, e);
throw e;
}
#endregion
return(resultList);
}
///<sumary>
/// 通过主键获取数据对象
///</sumary>
/// <param name="RKEY">rkey</param>
///<returns>DATA0002对象</returns>
public DATA0002 getDATA0002ByRKEY(decimal rkey)
{
#region SQL
string sql = @"select top 1
isNull(rkey,0) as rkey
,
isNull(unit_code,'') as unit_code
,
isNull(unit_name,'') as unit_name
,
isNull(prod,'') as prod
,
isNull(purch,'') as purch
,
isNull(stock,'') as stock
,
isNull(quote,'') as quote
,
isNull(sell,'') as sell
,
isNull(unit_base,'') as unit_base
,
isNull(derived,'') as derived
,
isNull(int_check,'') as int_check
,
isNull(expression,'') as expression
,
isNull(min_unit_value,0) as min_unit_value
,
isNull(max_unit_value,0) as max_unit_value
,
isNull(unit_type,'') as unit_type
,
isNull(pot_outer_layer,0) as pot_outer_layer
,
isNull(pot_inner_layer,0) as pot_inner_layer
,
isNull(active_flag,0) as active_flag
,
isNull(ecn_flag,'') as ecn_flag
from DATA0002 with (nolock) where RKEY='{0}'" ;
#endregion
///定义返回对象
DATA0002 data0002 = null;
#region 数据库操作
try
{
data0002 = new DATA0002();
using (DataTable tb = dbHelper.GetDataSet(string.Format(sql, rkey)))
{
foreach (DataRow row in tb.Rows)
{
data0002.RKEY = decimal.Parse(row["RKEY"].ToString());
data0002.UNIT_CODE = row["UNIT_CODE"].ToString();
data0002.UNIT_NAME = row["UNIT_NAME"].ToString();
data0002.PROD = row["PROD"].ToString();
data0002.PURCH = row["PURCH"].ToString();
data0002.STOCK = row["STOCK"].ToString();
data0002.QUOTE = row["QUOTE"].ToString();
data0002.SELL = row["SELL"].ToString();
data0002.UNIT_BASE = row["UNIT_BASE"].ToString();
data0002.DERIVED = row["DERIVED"].ToString();
data0002.INT_CHECK = row["INT_CHECK"].ToString();
data0002.EXPRESSION = row["EXPRESSION"].ToString();
data0002.MIN_UNIT_VALUE = decimal.Parse(row["MIN_UNIT_VALUE"].ToString());
data0002.MAX_UNIT_VALUE = decimal.Parse(row["MAX_UNIT_VALUE"].ToString());
data0002.UNIT_TYPE = row["UNIT_TYPE"].ToString();
data0002.POT_OUTER_LAYER = decimal.Parse(row["POT_OUTER_LAYER"].ToString());
data0002.POT_INNER_LAYER = decimal.Parse(row["POT_INNER_LAYER"].ToString());
data0002.ACTIVE_FLAG = decimal.Parse(row["ACTIVE_FLAG"].ToString());
data0002.ECN_FLAG = row["ECN_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(data0002);
}
public void Update(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0002 model)
{
#region 创建语法
StringBuilder strSql = new StringBuilder();
strSql.Append("update DATA0002 set ");
strSql.Append("UNIT_CODE=@UNIT_CODE,");
strSql.Append("UNIT_NAME=@UNIT_NAME,");
strSql.Append("PROD=@PROD,");
strSql.Append("PURCH=@PURCH,");
strSql.Append("STOCK=@STOCK,");
strSql.Append("QUOTE=@QUOTE,");
strSql.Append("SELL=@SELL,");
strSql.Append("UNIT_BASE=@UNIT_BASE,");
strSql.Append("DERIVED=@DERIVED,");
strSql.Append("INT_CHECK=@INT_CHECK,");
strSql.Append("EXPRESSION=@EXPRESSION,");
strSql.Append("MIN_UNIT_VALUE=@MIN_UNIT_VALUE,");
strSql.Append("MAX_UNIT_VALUE=@MAX_UNIT_VALUE,");
strSql.Append("UNIT_TYPE=@UNIT_TYPE,");
strSql.Append("POT_OUTER_LAYER=@POT_OUTER_LAYER,");
strSql.Append("POT_INNER_LAYER=@POT_INNER_LAYER,");
strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,");
strSql.Append("ECN_FLAG=@ECN_FLAG");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Decimal, 9),
new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 5),
new SqlParameter("@UNIT_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@PROD", SqlDbType.Char, 1),
new SqlParameter("@PURCH", SqlDbType.Char, 1),
new SqlParameter("@STOCK", SqlDbType.Char, 1),
new SqlParameter("@QUOTE", SqlDbType.Char, 1),
new SqlParameter("@SELL", SqlDbType.Char, 1),
new SqlParameter("@UNIT_BASE", SqlDbType.Char, 1),
new SqlParameter("@DERIVED", SqlDbType.Char, 1),
new SqlParameter("@INT_CHECK", SqlDbType.Char, 1),
new SqlParameter("@EXPRESSION", SqlDbType.VarChar, 50),
new SqlParameter("@MIN_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@MAX_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@UNIT_TYPE", SqlDbType.Char, 1),
new SqlParameter("@POT_OUTER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@POT_INNER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9),
new SqlParameter("@ECN_FLAG", SqlDbType.VarChar, 1)
};
parameters[0].Value = model.RKEY;
parameters[1].Value = model.UNIT_CODE;
parameters[2].Value = model.UNIT_NAME;
parameters[3].Value = model.PROD;
parameters[4].Value = model.PURCH;
parameters[5].Value = model.STOCK;
parameters[6].Value = model.QUOTE;
parameters[7].Value = model.SELL;
parameters[8].Value = model.UNIT_BASE;
parameters[9].Value = model.DERIVED;
parameters[10].Value = model.INT_CHECK;
parameters[11].Value = model.EXPRESSION;
parameters[12].Value = model.MIN_UNIT_VALUE;
parameters[13].Value = model.MAX_UNIT_VALUE;
parameters[14].Value = model.UNIT_TYPE;
parameters[15].Value = model.POT_OUTER_LAYER;
parameters[16].Value = model.POT_INNER_LAYER;
parameters[17].Value = model.ACTIVE_FLAG;
parameters[18].Value = model.ECN_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
}
///<sumary>
///修改
///</sumary>
/// <param name="DATA0002">model对象</param>
///<returns>返回INT类型号, 0为操作成功, 非0操作失败.</returns>
public int Update(DATA0002 model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DATA0002 set ");
strSql.Append("UNIT_CODE=@UNIT_CODE,");
strSql.Append("UNIT_NAME=@UNIT_NAME,");
strSql.Append("PROD=@PROD,");
strSql.Append("PURCH=@PURCH,");
strSql.Append("STOCK=@STOCK,");
strSql.Append("QUOTE=@QUOTE,");
strSql.Append("SELL=@SELL,");
strSql.Append("UNIT_BASE=@UNIT_BASE,");
strSql.Append("DERIVED=@DERIVED,");
strSql.Append("INT_CHECK=@INT_CHECK,");
strSql.Append("EXPRESSION=@EXPRESSION,");
strSql.Append("MIN_UNIT_VALUE=@MIN_UNIT_VALUE,");
strSql.Append("MAX_UNIT_VALUE=@MAX_UNIT_VALUE,");
strSql.Append("UNIT_TYPE=@UNIT_TYPE,");
strSql.Append("POT_OUTER_LAYER=@POT_OUTER_LAYER,");
strSql.Append("POT_INNER_LAYER=@POT_INNER_LAYER,");
strSql.Append("ACTIVE_FLAG=@ACTIVE_FLAG,");
strSql.Append("ECN_FLAG=@ECN_FLAG");
strSql.Append(" where RKEY=@RKEY ");
SqlParameter[] parameters =
{
new SqlParameter("@RKEY", SqlDbType.Decimal, 9),
new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 5),
new SqlParameter("@UNIT_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@PROD", SqlDbType.Char, 1),
new SqlParameter("@PURCH", SqlDbType.Char, 1),
new SqlParameter("@STOCK", SqlDbType.Char, 1),
new SqlParameter("@QUOTE", SqlDbType.Char, 1),
new SqlParameter("@SELL", SqlDbType.Char, 1),
new SqlParameter("@UNIT_BASE", SqlDbType.Char, 1),
new SqlParameter("@DERIVED", SqlDbType.Char, 1),
new SqlParameter("@INT_CHECK", SqlDbType.Char, 1),
new SqlParameter("@EXPRESSION", SqlDbType.VarChar, 50),
new SqlParameter("@MIN_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@MAX_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@UNIT_TYPE", SqlDbType.Char, 1),
new SqlParameter("@POT_OUTER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@POT_INNER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9),
new SqlParameter("@ECN_FLAG", SqlDbType.VarChar, 1)
};
parameters[0].Value = model.RKEY;
parameters[1].Value = model.UNIT_CODE;
parameters[2].Value = model.UNIT_NAME;
parameters[3].Value = model.PROD;
parameters[4].Value = model.PURCH;
parameters[5].Value = model.STOCK;
parameters[6].Value = model.QUOTE;
parameters[7].Value = model.SELL;
parameters[8].Value = model.UNIT_BASE;
parameters[9].Value = model.DERIVED;
parameters[10].Value = model.INT_CHECK;
parameters[11].Value = model.EXPRESSION;
parameters[12].Value = model.MIN_UNIT_VALUE;
parameters[13].Value = model.MAX_UNIT_VALUE;
parameters[14].Value = model.UNIT_TYPE;
parameters[15].Value = model.POT_OUTER_LAYER;
parameters[16].Value = model.POT_INNER_LAYER;
parameters[17].Value = model.ACTIVE_FLAG;
parameters[18].Value = model.ECN_FLAG;
return(dbHelper.ExecuteNonQuery(strSql.ToString(), parameters));
}
public int Add(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, DATA0002 model)
{
#region 创建SQL语法
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DATA0002(");
strSql.Append("UNIT_CODE,UNIT_NAME,PROD,PURCH,STOCK,QUOTE,SELL,UNIT_BASE,DERIVED,INT_CHECK,EXPRESSION,MIN_UNIT_VALUE,MAX_UNIT_VALUE,UNIT_TYPE,POT_OUTER_LAYER,POT_INNER_LAYER,ACTIVE_FLAG,ECN_FLAG)");
strSql.Append(" values (");
strSql.Append("@UNIT_CODE,@UNIT_NAME,@PROD,@PURCH,@STOCK,@QUOTE,@SELL,@UNIT_BASE,@DERIVED,@INT_CHECK,@EXPRESSION,@MIN_UNIT_VALUE,@MAX_UNIT_VALUE,@UNIT_TYPE,@POT_OUTER_LAYER,@POT_INNER_LAYER,@ACTIVE_FLAG,@ECN_FLAG)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 5),
new SqlParameter("@UNIT_NAME", SqlDbType.VarChar, 20),
new SqlParameter("@PROD", SqlDbType.Char, 1),
new SqlParameter("@PURCH", SqlDbType.Char, 1),
new SqlParameter("@STOCK", SqlDbType.Char, 1),
new SqlParameter("@QUOTE", SqlDbType.Char, 1),
new SqlParameter("@SELL", SqlDbType.Char, 1),
new SqlParameter("@UNIT_BASE", SqlDbType.Char, 1),
new SqlParameter("@DERIVED", SqlDbType.Char, 1),
new SqlParameter("@INT_CHECK", SqlDbType.Char, 1),
new SqlParameter("@EXPRESSION", SqlDbType.VarChar, 50),
new SqlParameter("@MIN_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@MAX_UNIT_VALUE", SqlDbType.Decimal, 13),
new SqlParameter("@UNIT_TYPE", SqlDbType.Char, 1),
new SqlParameter("@POT_OUTER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@POT_INNER_LAYER", SqlDbType.Decimal, 5),
new SqlParameter("@ACTIVE_FLAG", SqlDbType.Decimal, 9),
new SqlParameter("@ECN_FLAG", SqlDbType.VarChar, 1)
};
parameters[0].Value = model.UNIT_CODE;
parameters[1].Value = model.UNIT_NAME;
parameters[2].Value = model.PROD;
parameters[3].Value = model.PURCH;
parameters[4].Value = model.STOCK;
parameters[5].Value = model.QUOTE;
parameters[6].Value = model.SELL;
parameters[7].Value = model.UNIT_BASE;
parameters[8].Value = model.DERIVED;
parameters[9].Value = model.INT_CHECK;
parameters[10].Value = model.EXPRESSION;
parameters[11].Value = model.MIN_UNIT_VALUE;
parameters[12].Value = model.MAX_UNIT_VALUE;
parameters[13].Value = model.UNIT_TYPE;
parameters[14].Value = model.POT_OUTER_LAYER;
parameters[15].Value = model.POT_INNER_LAYER;
parameters[16].Value = model.ACTIVE_FLAG;
parameters[17].Value = model.ECN_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);
}
public void BinData(string strWhere)
{
try
{
DATA0017BLL bll = new DATA0017BLL(Frm.DBConnection);
DATA0002BLL bllD02 = new DATA0002BLL(Frm.DBConnection);
DATA0002 infoD02 = new DATA0002();
DataTable tb, tb2;
DataTable tb_GridView1;
DataRow dr;
string s_SQL;
tb_GridView1 = new DataTable();
tb_GridView1.Columns.Add("地点");
tb_GridView1.Columns.Add("可用库存");
tb_GridView1.Columns.Add("已分配库存");
tb = bll.getDataSet("select * from data0017 with (nolock) where rkey = " + Frm.id_rkey.ToString());
infoD02 = bllD02.getDATA0002ByRKEY(decimal.Parse(tb.Rows[0]["STOCK_UNIT_PTR"].ToString().Trim()));
Frm.textBoxInv_Part_Number.Text = tb.Rows[0]["inv_part_number"].ToString().Trim();
Frm.labelInv_Part_Desc.Text = tb.Rows[0]["INV_PART_DESCRIPTION"].ToString().Trim();
Frm.labelInv_Unit.Text = infoD02.UNIT_NAME.Trim();
s_SQL = @"
select data0016.CODE,
data0016.LOCATION,
data0019.QUAN_ON_HAND,
data0019.QUAN_ALLOCATED
from DATA0019 with (nolock),DATA0017 with (nolock),DATA0018 with (nolock),data0016 with (nolock)
where data0019.INVENTORY_PTR = data0017.RKEY
and data0019.INV_WHOUSE_PTR = data0018.RKEY
and data0019.LOCATION_PTR = data0016.RKEY
and data0017.rkey = " + Frm.id_rkey.ToString() + @"
order by data0016.CODE
";
tb = bll.getDataSet(s_SQL);
s_SQL = @"
SELECT (SUM(D467.QUAN_ORD) - SUM(D467.QUAN_RECD) + SUM(D467.QUAN_RETN) + SUM(D467.QUAN_IN_INSP)) AS ROQTY
FROM DATA0467 D467 WITH (NOLOCK) , DATA0466 D466 WITH (NOLOCK)
WHERE D467.RO_PTR = D466.RKEY
AND D467.INVT_PTR = " + Frm.id_rkey.ToString() + @"
AND (D467.QUAN_ORD) - (D467.QUAN_RECD) + (D467.QUAN_RETN) + (D467.QUAN_IN_INSP) > 0.0
AND D466.STATUS = 1
";
tb2 = bll.getDataSet(s_SQL);
for (int i = 0; i < tb.Rows.Count; i++)
{
dr = tb_GridView1.NewRow();
dr[0] = tb.Rows[i]["LOCATION"].ToString().Trim();
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_ON_HAND"].ToString().Trim()).ToString("#0.00");
dr[2] = decimal.Parse(tb.Rows[0]["QUAN_ALLOCATED"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
}
Frm.dataGridView1.DataSource = tb_GridView1;
Frm.dataGridView1.Columns[0].Width = 150;
Frm.dataGridView1.Columns[0].ReadOnly = true;
Frm.dataGridView1.Columns[1].Width = 150;
Frm.dataGridView1.Columns[1].ReadOnly = true;
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
public void BinData(string strWhere)
{
try
{
DATA0017BLL bll = new DATA0017BLL(Frm.DBConnection);
DATA0002BLL bllD02 = new DATA0002BLL(Frm.DBConnection);
DATA0002 infoD02 = new DATA0002();
DataTable tb, tb2;
DataTable tb_GridView1, tb_GridView2;
DataRow dr;
string s_SQL;
tb_GridView1 = new DataTable();
tb_GridView1.Columns.Add("名称");
tb_GridView1.Columns.Add("库存");
tb_GridView2 = new DataTable();
tb_GridView2.Columns.Add("名称");
tb_GridView2.Columns.Add("库存");
tb = bll.getDataSet("select * from data0017 with (nolock) where rkey = " + Frm.id_rkey.ToString());
infoD02 = bllD02.getDATA0002ByRKEY(decimal.Parse(tb.Rows[0]["STOCK_UNIT_PTR"].ToString().Trim()));
Frm.textBoxInv_Part_Number.Text = tb.Rows[0]["inv_part_number"].ToString().Trim();
Frm.labelInv_Part_Desc.Text = tb.Rows[0]["INV_PART_DESCRIPTION"].ToString().Trim();
Frm.labelInv_Unit.Text = infoD02.UNIT_NAME.Trim();
s_SQL = @"
SELECT isnull((SUM(D467.QUAN_ORD) - SUM(D467.QUAN_RECD) + SUM(D467.QUAN_RETN) + SUM(D467.QUAN_IN_INSP)),0) AS ROQTY
FROM DATA0467 D467 WITH (NOLOCK) , DATA0466 D466 WITH (NOLOCK)
WHERE D467.RO_PTR = D466.RKEY
AND D467.INVT_PTR = " + Frm.id_rkey.ToString() + @"
AND (D467.QUAN_ORD) - (D467.QUAN_RECD) + (D467.QUAN_RETN) + (D467.QUAN_IN_INSP) > 0.0
AND D466.STATUS = 1
";
tb2 = bll.getDataSet(s_SQL);
Frm.groupBox1.Text = "仓库总库存：" + decimal.Parse(tb.Rows[0]["QUAN_ON_HAND"].ToString()).ToString("#0.00");
Frm.groupBox2.Text = "寄售仓总库存：" + decimal.Parse(tb.Rows[0]["CONSIGN_ONHAND_QTY"].ToString()).ToString("#0.00");
#region 仓库
dr = tb_GridView1.NewRow();
dr[0] = "在途数量";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_IN_TRANSIT"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "在检数量";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_IN_INSP"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "待入库数量";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_BACKLOG"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "可用库存";
dr[1] = (decimal.Parse(tb.Rows[0]["QUAN_ON_HAND"].ToString().Trim()) - decimal.Parse(tb.Rows[0]["QUAN_ALLOCATED"].ToString().Trim())).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
dr = tb_GridView1.NewRow();
dr[0] = "已分配库存";
dr[1] = decimal.Parse(tb.Rows[0]["QUAN_ALLOCATED"].ToString().Trim()).ToString("#0.00");
tb_GridView1.Rows.Add(dr);
#endregion
#region 寄售
dr = tb_GridView2.NewRow();
dr[0] = "待检数量";
dr[1] = decimal.Parse(tb.Rows[0]["CONSIGN_QTY_IN_INSP"].ToString().Trim()).ToString("#0.00");
tb_GridView2.Rows.Add(dr);
dr = tb_GridView2.NewRow();
dr[0] = "开立RO数量";
if (tb2.Rows.Count > 0)
{
dr[1] = decimal.Parse(tb2.Rows[0]["ROQTY"].ToString().Trim()).ToString("#0.00");
}
else
{
dr[1] = "0";
}
tb_GridView2.Rows.Add(dr);
#endregion
Frm.dataGridView1.DataSource = tb_GridView1;
Frm.dataGridView1.Columns[0].Width = 150;
Frm.dataGridView1.Columns[0].ReadOnly = true;
Frm.dataGridView1.Columns[1].Width = 150;
Frm.dataGridView1.Columns[1].ReadOnly = true;
Frm.dataGridView2.DataSource = tb_GridView2;
Frm.dataGridView2.Columns[0].Width = 150;
Frm.dataGridView2.Columns[0].ReadOnly = true;
Frm.dataGridView2.Columns[1].Width = 150;
Frm.dataGridView2.Columns[1].ReadOnly = true;
}
catch (Exception e1)
{
log.PrintInfo(e1);
return;
}
}
