/// <summary>
/// 增加
/// </summary>
/// <param name="table"></param>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
model.INA001 = getCode( );
addHeader(model, SQLString);
MulaolaoLibrary.InvenAdSheetINBEntity body = new MulaolaoLibrary.InvenAdSheetINBEntity( );
body.INB001 = model.INA001;
foreach (DataRow row in table.Rows)
{
body.INB002 = row ["INB002"].ToString( );
body.INB003 = row ["INB003"].ToString( );
body.INB004 = row ["INB004"].ToString( );
body.INB005 = row ["INB005"].ToString( );
body.INB006 = row ["INB006"].ToString( );
body.INB007 = string.IsNullOrEmpty(row ["INB007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB007"]);
body.INB008 = row ["INB008"].ToString( );
body.INB009 = row ["INB009"].ToString( );
body.INB010 = string.IsNullOrEmpty(row ["INB010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB010"]);
body.INB011 = string.IsNullOrEmpty(row ["INB011"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB011"]);
body.INB012 = string.IsNullOrEmpty(row ["INB012"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB012"]);
body.INB013 = string.IsNullOrEmpty(row ["INB013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB013"]);
body.INB014 = row ["INB014"].ToString( );
body.INB015 = string.IsNullOrEmpty(row ["INB015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB015"]);
body.INB016 = row ["INB016"].ToString( );
addBody(body, SQLString);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void addBody(MulaolaoLibrary.InvenAdSheetINBEntity model, Dictionary <object, object> SQLString)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into R_INB(");
strSql.Append("INB001,INB002,INB003,INB004,INB005,INB006,INB007,INB008,INB009,INB010,INB011,INB012,INB013,INB014,INB015,INB016)");
strSql.Append(" values (");
strSql.Append("@INB001,@INB002,@INB003,@INB004,@INB005,@INB006,@INB007,@INB008,@INB009,@INB010,@INB011,@INB012,@INB013,@INB014,@INB015,@INB016)");
SqlParameter [] parameters =
{
new SqlParameter("@INB001", SqlDbType.NVarChar, 20),
new SqlParameter("@INB002", SqlDbType.NVarChar, 20),
new SqlParameter("@INB003", SqlDbType.NVarChar, 100),
new SqlParameter("@INB004", SqlDbType.NVarChar, 20),
new SqlParameter("@INB005", SqlDbType.NVarChar, 50),
new SqlParameter("@INB006", SqlDbType.NVarChar, 50),
new SqlParameter("@INB007", SqlDbType.Decimal, 9),
new SqlParameter("@INB008", SqlDbType.NVarChar, 50),
new SqlParameter("@INB009", SqlDbType.NVarChar, 50),
new SqlParameter("@INB010", SqlDbType.Decimal, 9),
new SqlParameter("@INB011", SqlDbType.Decimal, 9),
new SqlParameter("@INB012", SqlDbType.Decimal, 9),
new SqlParameter("@INB013", SqlDbType.Decimal, 9),
new SqlParameter("@INB014", SqlDbType.NVarChar, 5),
new SqlParameter("@INB015", SqlDbType.NChar, 10),
new SqlParameter("@INB016", SqlDbType.NVarChar, 5)
};
parameters [0].Value = model.INB001;
parameters [1].Value = model.INB002;
parameters [2].Value = model.INB003;
parameters [3].Value = model.INB004;
parameters [4].Value = model.INB005;
parameters [5].Value = model.INB006;
parameters [6].Value = model.INB007;
parameters [7].Value = model.INB008;
parameters [8].Value = model.INB009;
parameters [9].Value = model.INB010;
parameters [10].Value = model.INB011;
parameters [11].Value = model.INB012;
parameters [12].Value = model.INB013;
parameters [13].Value = model.INB014;
parameters [14].Value = model.INB015;
parameters [15].Value = model.INB016;
SQLString.Add(strSql, parameters);
}
public FormInvenAdSheet( )
{
InitializeComponent( );
_bll = new MulaolaoBll.Bll.InvenAdSheetBll( );
model = new MulaolaoLibrary.InvenAdSheetINAEntity( );
body = new MulaolaoLibrary.InvenAdSheetINBEntity( );
toolStrip1.Items.Remove(toolPrint);
toolStrip1.Items.Remove(toolExport);
toolStrip1.Items.Remove(toolLibrary);
toolStrip1.Items.Remove(toolStorage);
toolStrip1.Items.Remove(toolcopy);
controlUnEnable( );
dt = MulaolaoBll.Drity.GetDt( );
label45.Visible = false;
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="table"></param>
/// <param name="model"></param>
/// <param name="strList"></param>
/// <returns></returns>
public bool Edit(DataTable table, MulaolaoLibrary.InvenAdSheetINAEntity model, List <string> strList)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
editHeader(model, SQLString);
MulaolaoLibrary.InvenAdSheetINBEntity body = new MulaolaoLibrary.InvenAdSheetINBEntity( );
body.INB001 = model.INA001;
foreach (DataRow row in table.Rows)
{
body.id = string.IsNullOrEmpty(row ["id"].ToString( )) == true ? 0 : Convert.ToInt32(row ["id"]);
body.INB002 = row ["INB002"].ToString( );
body.INB003 = row ["INB003"].ToString( );
body.INB004 = row ["INB004"].ToString( );
body.INB005 = row ["INB005"].ToString( );
body.INB006 = row ["INB006"].ToString( );
body.INB007 = string.IsNullOrEmpty(row ["INB007"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB007"]);
body.INB008 = row ["INB008"].ToString( );
body.INB009 = row ["INB009"].ToString( );
body.INB010 = string.IsNullOrEmpty(row ["INB010"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB010"]);
body.INB011 = string.IsNullOrEmpty(row ["INB011"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB011"]);
body.INB012 = string.IsNullOrEmpty(row ["INB012"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB012"]);
body.INB013 = string.IsNullOrEmpty(row ["INB013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB013"]);
body.INB014 = row ["INB014"].ToString( );
body.INB015 = string.IsNullOrEmpty(row ["INB015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB015"]);
body.INB016 = row ["INB016"].ToString( );
if (body.id <= 1)
{
addBody(body, SQLString);
}
else
{
editBody(body, SQLString);
}
}
foreach (string s in strList)
{
deleteBody(s, SQLString);
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void editCK(Hashtable SQLString, MulaolaoLibrary.InvenAdSheetINBEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQAD SET ");
strSql.Append("AD20=@AD20,");
strSql.Append("AD21=@AD21 ");
strSql.Append("WHERE AD01=@AD01 AND AD17=@AD17 ");
SqlParameter [] parameter =
{
new SqlParameter("@AD01", SqlDbType.NVarChar),
new SqlParameter("@AD17", SqlDbType.NVarChar),
new SqlParameter("@AD20", SqlDbType.Decimal),
new SqlParameter("@AD21", SqlDbType.Decimal)
};
parameter [0].Value = model.INB002;
parameter [1].Value = model.INB003;
parameter [2].Value = model.INB007;
parameter [3].Value = model.INB012;
SQLString.Add(strSql, parameter);
}
void editRK(Hashtable SQLString, MulaolaoLibrary.InvenAdSheetINBEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE R_PQAC SET ");
strSql.Append("AC26=@AC26,");
strSql.Append("AC27=@AC27 ");
strSql.Append("WHERE AC18=@AC18 AND AC16=@AC16 ");
SqlParameter [] parameter =
{
new SqlParameter("@AC16", SqlDbType.NVarChar),
new SqlParameter("@AC18", SqlDbType.NVarChar),
new SqlParameter("@AC26", SqlDbType.Decimal),
new SqlParameter("@AC27", SqlDbType.Decimal)
};
parameter [0].Value = model.INB003;
parameter [1].Value = model.INB002;
parameter [2].Value = model.INB007;
parameter [3].Value = model.INB012;
SQLString.Add(strSql, parameter);
}
/// <summary>
/// 回写数据到464中
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public bool writeTo(string code)
{
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT A.INB002,A.INB003,INA003,SUM(CONVERT(FLOAT,INB014+CONVERT(NVARCHAR,INB013))) INB013,SUM(CONVERT(FLOAT,INB016+CONVERT(NVARCHAR,INB015))) INB015 FROM R_INB A INNER JOIN (SELECT INB002,INB003,INA003 FROM R_INA A INNER JOIN R_INB B ON A.INA001=B.INB001 WHERE INA001='{0}') B ON A.INB002=B.INB002 AND A.INB003=B.INB003 GROUP BY A.INB002,A.INB003,INA003", code);
DataTable table = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (table == null || table.Rows.Count < 1)
{
return(true);
}
else
{
MulaolaoLibrary.InvenAdSheetINBEntity model = new MulaolaoLibrary.InvenAdSheetINBEntity( );
foreach (DataRow row in table.Rows)
{
model.INB001 = row ["INA003"].ToString( );
model.INB002 = row ["INB002"].ToString( );
model.INB003 = row ["INB003"].ToString( );
model.INB007 = string.IsNullOrEmpty(row ["INB015"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB015"]);
model.INB012 = string.IsNullOrEmpty(row ["INB013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["INB013"]);
if (model.INB001.Equals("入库"))
{
editRK(SQLString, model);
}
else
{
editCK(SQLString, model);
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
void editBody(MulaolaoLibrary.InvenAdSheetINBEntity model, Dictionary <object, object> SQLString)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update R_INB set ");
strSql.Append("INB001=@INB001,");
strSql.Append("INB002=@INB002,");
strSql.Append("INB003=@INB003,");
strSql.Append("INB004=@INB004,");
strSql.Append("INB005=@INB005,");
strSql.Append("INB006=@INB006,");
strSql.Append("INB007=@INB007,");
strSql.Append("INB008=@INB008,");
strSql.Append("INB009=@INB009,");
strSql.Append("INB010=@INB010,");
strSql.Append("INB011=@INB011,");
strSql.Append("INB012=@INB012,");
strSql.Append("INB013=@INB013,");
strSql.Append("INB014=@INB014,");
strSql.Append("INB015=@INB015,");
strSql.Append("INB016=@INB016");
strSql.Append(" where id=@id");
SqlParameter [] parameters =
{
new SqlParameter("@INB001", SqlDbType.NVarChar, 20),
new SqlParameter("@INB002", SqlDbType.NVarChar, 20),
new SqlParameter("@INB003", SqlDbType.NVarChar, 100),
new SqlParameter("@INB004", SqlDbType.NVarChar, 20),
new SqlParameter("@INB005", SqlDbType.NVarChar, 50),
new SqlParameter("@INB006", SqlDbType.NVarChar, 50),
new SqlParameter("@INB007", SqlDbType.Decimal, 9),
new SqlParameter("@INB008", SqlDbType.NVarChar, 50),
new SqlParameter("@INB009", SqlDbType.NVarChar, 50),
new SqlParameter("@INB010", SqlDbType.Decimal, 9),
new SqlParameter("@INB011", SqlDbType.Decimal, 9),
new SqlParameter("@INB012", SqlDbType.Decimal, 9),
new SqlParameter("@INB013", SqlDbType.Decimal, 9),
new SqlParameter("@INB014", SqlDbType.NVarChar, 5),
new SqlParameter("@INB015", SqlDbType.NChar, 10),
new SqlParameter("@INB016", SqlDbType.NVarChar, 5),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters [0].Value = model.INB001;
parameters [1].Value = model.INB002;
parameters [2].Value = model.INB003;
parameters [3].Value = model.INB004;
parameters [4].Value = model.INB005;
parameters [5].Value = model.INB006;
parameters [6].Value = model.INB007;
parameters [7].Value = model.INB008;
parameters [8].Value = model.INB009;
parameters [9].Value = model.INB010;
parameters [10].Value = model.INB011;
parameters [11].Value = model.INB012;
parameters [12].Value = model.INB013;
parameters [13].Value = model.INB014;
parameters [14].Value = model.INB015;
parameters [15].Value = model.INB016;
parameters [16].Value = model.id;
SQLString.Add(strSql, parameters);
}
