/// <summary>
/// 审核
/// </summary>
/// <param name="oddNum"></param>
/// <param name="result"></param>
/// <returns></returns>
public bool Exanmie(LineProductMesEntityu.PaintNewspaperHeaderEntity model)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE MIKPAN SET PAN009=@PAN009 WHERE PAN001=@PAN001");
SqlParameter [] parameter =
{
new SqlParameter("@PAN001", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN009", SqlDbType.Bit)
};
parameter [0].Value = model.PAN001;
parameter [1].Value = model.PAN009;
SQLString.Add(strSql, parameter);
if (model.PAN009)
{
strSql = new StringBuilder( );
strSql.AppendFormat("SELECT PAO002 ANN002,PAO003 ANN003,PAO008 ANN005,PAO012 ANN009,DDA001 FROM MIKPAO A LEFT JOIN TPADEA B ON A.PAO003=B.DEA001 INNER JOIN TPADDA C ON B.DEA008=C.DDA001 WHERE PAO001='{0}'", model.PAN001);
GenerateSGMRCACB.GenerateSGM(SQLString, strSql, model.PAN001, model.PAN004);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
void AddHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.PaintNewspaperHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKPAN(");
strSql.Append("PAN001,PAN002,PAN003,PAN004,PAN005,PAN006,PAN007,PAN008,PAN009,PAN010,PAN011,PAN012,PAN013,PAN014,PAN015,PAN016,PAN017,PAN018)");
strSql.Append(" values (");
strSql.Append("@PAN001,@PAN002,@PAN003,@PAN004,@PAN005,@PAN006,@PAN007,@PAN008,@PAN009,@PAN010,@PAN011,@PAN012,@PAN013,@PAN014,@PAN015,@PAN016,@PAN017,@PAN018)");
SqlParameter [] parameters =
{
new SqlParameter("@PAN001", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN002", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN003", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN004", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN005", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN006", SqlDbType.Date, 3),
new SqlParameter("@PAN007", SqlDbType.NVarChar, 100),
new SqlParameter("@PAN008", SqlDbType.NVarChar, 100),
new SqlParameter("@PAN009", SqlDbType.Bit, 1),
new SqlParameter("@PAN010", SqlDbType.Bit, 1),
new SqlParameter("@PAN011", SqlDbType.Decimal),
new SqlParameter("@PAN012", SqlDbType.Decimal),
new SqlParameter("@PAN013", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN014", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN015", SqlDbType.DateTime),
new SqlParameter("@PAN016", SqlDbType.DateTime),
new SqlParameter("@PAN017", SqlDbType.Decimal),
new SqlParameter("@PAN018", SqlDbType.Decimal)
};
parameters [0].Value = model.PAN001;
parameters [1].Value = model.PAN002;
parameters [2].Value = model.PAN003;
parameters [3].Value = model.PAN004;
parameters [4].Value = model.PAN005;
parameters [5].Value = model.PAN006;
parameters [6].Value = model.PAN007;
parameters [7].Value = model.PAN008;
parameters [8].Value = model.PAN009;
parameters [9].Value = model.PAN010;
parameters [10].Value = model.PAN011;
parameters [11].Value = model.PAN012;
parameters [12].Value = model.PAN013;
parameters [13].Value = model.PAN014;
parameters [14].Value = model.PAN015;
parameters [15].Value = model.PAN016;
parameters [16].Value = model.PAN017;
parameters [17].Value = model.PAN018;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 审核
/// </summary>
/// <param name="oddNum"></param>
/// <param name="result"></param>
/// <returns></returns>
public bool Exanmie(LineProductMesEntityu.PaintNewspaperHeaderEntity model)
{
return(dal.Exanmie(model));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableViewOne"></param>
/// <param name="tableViewTwo"></param>
/// <param name="idxListOne"></param>
/// <param name="idxListTwo"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.PaintNewspaperHeaderEntity model, DataTable tableViewOne, DataTable tableViewTwo, List <string> idxListOne, List <string> idxListTwo)
{
return(dal.Edit(model, tableViewOne, tableViewTwo, idxListOne, idxListTwo));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableViewOne"></param>
/// <param name="tableViewTwo"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.PaintNewspaperHeaderEntity model, DataTable tableViewOne, DataTable tableViewTwo)
{
return(dal.Save(model, tableViewOne, tableViewTwo));
}
public LineProductMesEntityu.PaintNewspaperHeaderEntity getModel(DataRow row)
{
LineProductMesEntityu.PaintNewspaperHeaderEntity model = new LineProductMesEntityu.PaintNewspaperHeaderEntity( );
if (row != null)
{
if (row ["idx"] != null && row ["idx"].ToString( ) != "")
{
model.idx = int.Parse(row ["idx"].ToString( ));
}
if (row ["PAN001"] != null)
{
model.PAN001 = row ["PAN001"].ToString( );
}
if (row ["PAN002"] != null)
{
model.PAN002 = row ["PAN002"].ToString( );
}
if (row ["PAN003"] != null)
{
model.PAN003 = row ["PAN003"].ToString( );
}
if (row ["PAN004"] != null)
{
model.PAN004 = row ["PAN004"].ToString( );
}
if (row ["PAN005"] != null)
{
model.PAN005 = row ["PAN005"].ToString( );
}
if (row ["PAN006"] != null && row ["PAN006"].ToString( ) != "")
{
model.PAN006 = DateTime.Parse(row ["PAN006"].ToString( ));
}
if (row ["PAN007"] != null)
{
model.PAN007 = row ["PAN007"].ToString( );
}
if (row ["PAN008"] != null)
{
model.PAN008 = row ["PAN008"].ToString( );
}
if (row ["PAN009"] != null && row ["PAN009"].ToString( ) != "")
{
if ((row ["PAN009"].ToString( ) == "1") || (row ["PAN009"].ToString( ).ToLower( ) == "true"))
{
model.PAN009 = true;
}
else
{
model.PAN009 = false;
}
}
if (row ["PAN010"] != null && row ["PAN010"].ToString( ) != "")
{
if ((row ["PAN010"].ToString( ) == "1") || (row ["PAN010"].ToString( ).ToLower( ) == "true"))
{
model.PAN010 = true;
}
else
{
model.PAN010 = false;
}
}
if (row ["PAN011"] != null && row ["PAN011"].ToString( ) != "")
{
model.PAN011 = decimal.Parse(row ["PAN011"].ToString( ));
}
if (row ["PAN012"] != null && row ["PAN012"].ToString( ) != "")
{
model.PAN012 = decimal.Parse(row ["PAN012"].ToString( ));
}
if (row ["PAN013"] != null && row ["PAN013"].ToString( ) != "")
{
model.PAN013 = row ["PAN013"].ToString( );
}
if (row ["PAN014"] != null && row ["PAN014"].ToString( ) != "")
{
model.PAN014 = row ["PAN014"].ToString( );
}
if (row ["PAN015"] != null && row ["PAN015"].ToString( ) != "")
{
model.PAN015 = DateTime.Parse(row ["PAN015"].ToString( ));
}
if (row ["PAN016"] != null && row ["PAN016"].ToString( ) != "")
{
model.PAN016 = DateTime.Parse(row ["PAN016"].ToString( ));
}
if (row ["PAN017"] != null && row ["PAN017"].ToString( ) != "")
{
model.PAN017 = decimal.Parse(row ["PAN017"].ToString( ));
}
if (row ["PAN018"] != null && row ["PAN018"].ToString( ) != "")
{
model.PAN018 = decimal.Parse(row ["PAN018"].ToString( ));
}
}
return(model);
}
void EditHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.PaintNewspaperHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("update MIKPAN set ");
strSql.Append("PAN002=@PAN002,");
strSql.Append("PAN003=@PAN003,");
strSql.Append("PAN004=@PAN004,");
strSql.Append("PAN005=@PAN005,");
strSql.Append("PAN006=@PAN006,");
strSql.Append("PAN007=@PAN007,");
strSql.Append("PAN008=@PAN008,");
strSql.Append("PAN009=@PAN009,");
strSql.Append("PAN010=@PAN010,");
strSql.Append("PAN011=@PAN011,");
strSql.Append("PAN012=@PAN012,");
strSql.Append("PAN013=@PAN013,");
strSql.Append("PAN015=@PAN015,");
strSql.Append("PAN016=@PAN016,");
strSql.Append("PAN017=@PAN017,");
strSql.Append("PAN018=@PAN018 ");
strSql.Append(" where PAN001=@PAN001");
SqlParameter [] parameters =
{
new SqlParameter("@PAN002", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN003", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN004", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN005", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN006", SqlDbType.Date, 3),
new SqlParameter("@PAN007", SqlDbType.NVarChar, 100),
new SqlParameter("@PAN008", SqlDbType.NVarChar, 100),
new SqlParameter("@PAN009", SqlDbType.Bit, 1),
new SqlParameter("@PAN010", SqlDbType.Bit, 1),
new SqlParameter("@PAN001", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN011", SqlDbType.Decimal),
new SqlParameter("@PAN012", SqlDbType.Decimal),
new SqlParameter("@PAN013", SqlDbType.NVarChar, 20),
new SqlParameter("@PAN015", SqlDbType.DateTime),
new SqlParameter("@PAN016", SqlDbType.DateTime),
new SqlParameter("@PAN017", SqlDbType.Decimal),
new SqlParameter("@PAN018", SqlDbType.Decimal)
};
parameters [0].Value = model.PAN002;
parameters [1].Value = model.PAN003;
parameters [2].Value = model.PAN004;
parameters [3].Value = model.PAN005;
parameters [4].Value = model.PAN006;
parameters [5].Value = model.PAN007;
parameters [6].Value = model.PAN008;
parameters [7].Value = model.PAN009;
parameters [8].Value = model.PAN010;
parameters [9].Value = model.PAN001;
parameters [10].Value = model.PAN011;
parameters [11].Value = model.PAN012;
parameters [12].Value = model.PAN013;
parameters [13].Value = model.PAN015;
parameters [14].Value = model.PAN016;
parameters [15].Value = model.PAN017;
parameters [16].Value = model.PAN018;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="tableViewOne"></param>
/// <param name="tableViewTwo"></param>
/// <param name="idxListOne"></param>
/// <param name="idxListTwo"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.PaintNewspaperHeaderEntity model, DataTable tableViewOne, DataTable tableViewTwo, List <string> idxListOne, List <string> idxListTwo)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
//model . PAN001 = getOddNum ( );
//UserInfoMation . oddNum = model . PAN001;
EditHeader(SQLString, model);
LineProductMesEntityu.PaintNewspaperBodyOneEntity modelOne = new LineProductMesEntityu.PaintNewspaperBodyOneEntity( );
modelOne.PAO001 = model.PAN001;
foreach (DataRow row in tableViewOne.Rows)
{
modelOne.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
modelOne.PAO002 = row ["PAO002"].ToString( );
modelOne.PAO003 = row ["PAO003"].ToString( );
modelOne.PAO004 = row ["PAO004"].ToString( );
modelOne.PAO005 = string.IsNullOrEmpty(row ["PAO005"].ToString( )) == true ? 0 : Convert.ToInt32(row ["PAO005"].ToString( ));
modelOne.PAO006 = string.IsNullOrEmpty(row ["PAO006"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["PAO006"].ToString( ));
modelOne.PAO007 = row ["PAO007"].ToString( );
modelOne.PAO008 = row ["PAO008"].ToString( );
modelOne.PAO009 = row ["PAO009"].ToString( );
modelOne.PAO010 = row ["PAO010"].ToString( );
modelOne.PAO011 = string.IsNullOrEmpty(row ["PAO011"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["PAO011"].ToString( ));
modelOne.PAO012 = string.IsNullOrEmpty(row ["PAO012"].ToString( )) == true ? 0 : Convert.ToInt32(row ["PAO012"].ToString( ));
modelOne.PAO013 = row ["PAO013"].ToString( );
modelOne.PAO014 = row ["PAO014"].ToString( );
if (modelOne.idx < 1)
{
AddBodyOne(SQLString, modelOne);
}
else
{
EditBodyOne(SQLString, modelOne);
}
}
foreach (string s in idxListOne)
{
DeleteOne(SQLString, s);
}
LineProductMesEntityu.PaintNewspaperBodyTwoEntity modelTwo = new LineProductMesEntityu.PaintNewspaperBodyTwoEntity( );
modelTwo.PAP001 = model.PAN001;
foreach (DataRow row in tableViewTwo.Rows)
{
modelTwo.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"].ToString( ));
modelTwo.PPA002 = row ["PPA002"].ToString( );
modelTwo.PPA003 = row ["PPA003"].ToString( );
modelTwo.PPA004 = row ["PPA004"].ToString( );
if (row ["PPA005"] == null || row ["PPA005"].ToString( ) == string.Empty)
{
modelTwo.PPA005 = null;
}
else
{
modelTwo.PPA005 = Convert.ToDateTime(row ["PPA005"].ToString( ));
}
if (row ["PPA006"] == null || row ["PPA006"].ToString( ) == string.Empty)
{
modelTwo.PPA006 = null;
}
else
{
modelTwo.PPA006 = Convert.ToDateTime(row ["PPA006"].ToString( ));
}
if (row ["PPA007"] == null || row ["PPA007"].ToString( ) == string.Empty)
{
modelTwo.PPA007 = null;
}
else
{
modelTwo.PPA007 = Convert.ToDateTime(row ["PPA007"].ToString( ));
}
if (row ["PPA008"] == null || row ["PPA008"].ToString( ) == string.Empty)
{
modelTwo.PPA008 = null;
}
else
{
modelTwo.PPA008 = Convert.ToDateTime(row ["PPA008"].ToString( ));
}
modelTwo.PPA009 = string.IsNullOrEmpty(row ["PPA009"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["PPA009"].ToString( ));
modelTwo.PPA010 = row ["PPA010"].ToString( );
modelTwo.PPA011 = row ["PPA011"].ToString( );
modelTwo.PPA012 = string.IsNullOrEmpty(row ["PPA012"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["PPA012"].ToString( ));
modelTwo.PPA013 = string.IsNullOrEmpty(row ["PPA013"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["PPA013"].ToString( ));
modelTwo.PPA014 = string.IsNullOrEmpty(row ["PPA014"].ToString( )) == true ? 0 : Convert.ToDecimal(row ["PPA014"].ToString( ));
modelTwo.PPA015 = row ["PPA015"].ToString( );
if (row ["PPA016"] == null || row ["PPA016"].ToString( ) == string.Empty)
{
modelTwo.PPA016 = null;
}
else
{
modelTwo.PPA016 = Convert.ToDecimal(row ["PPA016"].ToString( ));
}
if (modelTwo.idx < 1)
{
AddBodyTwo(SQLString, modelTwo);
}
else
{
EditBodyTwo(SQLString, modelTwo);
}
}
foreach (string s in idxListTwo)
{
DeleteTwo(SQLString, s);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
