public LineProductMesEntityu.ProductPlanHeaderEntity getModel(DataRow row)
{
LineProductMesEntityu.ProductPlanHeaderEntity model = new LineProductMesEntityu.ProductPlanHeaderEntity( );
if (row != null)
{
if (row ["PRD001"] != null)
{
model.PRD001 = row ["PRD001"].ToString( );
}
if (row ["PRD002"] != null && row ["PRD002"].ToString( ) != "")
{
model.PRD002 = DateTime.Parse(row ["PRD002"].ToString( ));
}
if (row ["PRD003"] != null && row ["PRD003"].ToString( ) != "")
{
if ((row ["PRD003"].ToString( ) == "1") || (row ["PRD003"].ToString( ).ToLower( ) == "true"))
{
model.PRD003 = true;
}
else
{
model.PRD003 = false;
}
}
}
return(model);
}
/// <summary>
/// 复制
/// </summary>
/// <param name="table"></param>
/// <param name="oddNum"></param>
/// <returns></returns>
public bool Copy(DataTable table, string oddNum)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
LineProductMesEntityu.ProductPlanHeaderEntity model = new LineProductMesEntityu.ProductPlanHeaderEntity( );
model.PRD001 = getOddNum( );
model.PRD002 = UserInfoMation.sysTime;
model.PRD003 = false;
AddHeader(SQLString, model);
UserInfoMation.oddNum = model.PRD001;
LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( );
modelBody.PRE001 = model.PRD001;
foreach (DataRow row in table.Rows)
{
modelBody.PRE002 = row ["PRE002"].ToString( );
modelBody.PRE003 = row ["PRE003"].ToString( );
modelBody.PRE004 = row ["PRE004"].ToString( );
modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( ));
modelBody.PRE006 = Convert.ToDateTime(row ["PRE006"].ToString( ));
modelBody.PRE007 = Convert.ToInt32(row ["PRE007"].ToString( ));
modelBody.PRE008 = Convert.ToInt32(row ["PRE008"].ToString( ));
modelBody.PRE010 = Convert.ToInt32(row ["PRE010"].ToString( ));
AddBody(SQLString, modelBody);
}
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("UPDATE MIKPRD SET PRD003=1 WHERE PRD001='{0}'", oddNum);
SQLString.Add(strSql, null);
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
public FormProductPlan(/*DataRow rowedit*/)
{
InitializeComponent( );
_header = new LineProductMesEntityu.ProductPlanHeaderEntity( );
_body = new LineProductMesEntityu.ProductPlanBodyEntity( );
_bll = new LineProductMesBll.Bll.ProductPlanBll( );
ToolBarContain.ToolbarsC(barTool, new DevExpress.XtraBars.BarItem [] { toolExport, toolPrint });
GridViewMoHuSelect.SetFilter(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
GrivColumnStyle.setColumnStyle(new DevExpress.XtraGrid.Views.Grid.GridView [] { gridView1 });
FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic);
fi.SetValue(null, new DrawXPaint( ));
//toolExamin . Caption = "弃用";
//toolCancellation . Caption = "复制";
controlUnEnable( );
controlClear( );
dtTime = LineProductMesBll.UserInfoMation.sysTime;
toolCancellation.Caption = "生成ERP计划";
layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
//if ( rowedit != null )
//{
// this . rows = rowedit;
//}
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
model.PRD001 = getOddNum( );
UserInfoMation.oddNum = model.PRD001;
AddHeader(SQLString, model);
LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( );
modelBody.PRE001 = model.PRD001;
//StringBuilder strSql = new StringBuilder ( );
//strSql . Append ( "SELECT PRF001,PRF002 FROM MIKPRF " );
//DataTable tableR = SqlHelper . ExecuteDataTable ( strSql . ToString ( ) );
foreach (DataRow row in table.Rows)
{
modelBody.PRE002 = row ["PRE002"].ToString( );
modelBody.PRE003 = row ["PRE003"].ToString( );
modelBody.PRE004 = row ["PRE004"].ToString( );
modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( ));
modelBody.PRE006 = Convert.ToDateTime(row ["PRE006"].ToString( ));
modelBody.PRE007 = Convert.ToInt32(row ["PRE007"].ToString( ));
modelBody.PRE008 = Convert.ToInt32(row ["PRE008"].ToString( ));
if (string.IsNullOrEmpty(row ["PRE009"].ToString( )))
{
modelBody.PRE009 = null;
}
else
{
modelBody.PRE009 = Convert.ToInt32(row ["PRE009"].ToString( ));
}
modelBody.PRE010 = Convert.ToInt32(row ["PRE010"].ToString( ));
if (string.IsNullOrEmpty(row ["PRE011"].ToString( )))
{
modelBody.PRE011 = 0;
}
else
{
modelBody.PRE011 = Convert.ToInt32(row ["PRE011"].ToString( ));
}
modelBody.PRE008 = modelBody.PRE008 + modelBody.PRE011;
AddBody(SQLString, modelBody);
//if ( tableR != null && tableR . Rows . Count > 0 )
//{
// if ( tableR . Select ( "PRF001='" + modelBody . PRE004 + "' AND PRF002='" + modelBody . PRE005 + "'" ) . Length < 1 )
// Addprf ( SQLString ,modelBody );
// else
// Editprf ( SQLString ,modelBody );
//}
//else
// Addprf ( SQLString ,modelBody );
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
/// <summary>
/// 审核
/// </summary>
/// <param name="oddNum"></param>
/// <returns></returns>
public bool Examine(LineProductMesEntityu.ProductPlanHeaderEntity _header, DataTable table)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
StringBuilder strSql = new StringBuilder( );
strSql.Append("UPDATE MIKPRD SET PRD003=@PRD003 WHERE PRD001=@PRD001");
SqlParameter [] parameter =
{
new SqlParameter("@PRD001", SqlDbType.NVarChar, 20),
new SqlParameter("@PRD003", SqlDbType.Bit)
};
parameter [0].Value = _header.PRD001;
parameter [1].Value = _header.PRD003;
SQLString.Add(strSql, parameter);
LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( );
strSql = new StringBuilder( );
strSql.Append("SELECT PRF001,PRF002 FROM MIKPRF ");
DataTable tableR = SqlHelper.ExecuteDataTable(strSql.ToString( ));
foreach (DataRow row in table.Rows)
{
modelBody.PRE004 = row ["PRE004"].ToString( );
modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( ));
modelBody.PRE008 = Convert.ToInt32(row ["PRE008"].ToString( ));
if (string.IsNullOrEmpty(row ["PRE011"].ToString( )))
{
modelBody.PRE011 = 0;
}
else
{
modelBody.PRE011 = Convert.ToInt32(row ["PRE011"].ToString( ));
}
modelBody.PRE008 = modelBody.PRE008 + modelBody.PRE011;
if (tableR != null && tableR.Rows.Count > 0)
{
if (tableR.Select("PRF001='" + modelBody.PRE004 + "' AND PRF002='" + modelBody.PRE005 + "'").Length < 1)
{
Addprf(SQLString, modelBody);
}
else
{
Editprf(SQLString, modelBody);
}
}
else
{
Addprf(SQLString, modelBody);
}
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
protected override int Query( )
{
ChildForm.FormProductPlanQuery from = new ChildForm.FormProductPlanQuery( );
from.StartPosition = FormStartPosition.CenterParent;
if (from.ShowDialog( ) == DialogResult.OK)
{
_header.PRD001 = from.getOdd;
_header = _bll.getModel(_header.PRD001);
setValue( );
tableView = _bll.getTableView(_header.PRD001);
gridControl1.DataSource = tableView;
QueryTool( );
toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
if (_header.PRD003 == true)
{
toolExamin.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolCancellation.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
Graph.grPic(pictureEdit1, "审核");
}
else
{
toolExamin.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
toolCancellation.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Always;
layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
layoutControlItem4.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
Graph.grPic(pictureEdit1, "反审核");
}
gridView1.OptionsBehavior.Editable = false;
}
return(base.Query( ));
}
void AddHeader(Dictionary <object, object> SQLString, LineProductMesEntityu.ProductPlanHeaderEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.Append("insert into MIKPRD(");
strSql.Append("PRD001,PRD002,PRD003)");
strSql.Append(" values (");
strSql.Append("@PRD001,@PRD002,@PRD003)");
SqlParameter [] parameters =
{
new SqlParameter("@PRD001", SqlDbType.NVarChar, 20),
new SqlParameter("@PRD002", SqlDbType.Date, 3),
new SqlParameter("@PRD003", SqlDbType.Bit, 1)
};
parameters [0].Value = model.PRD001;
parameters [1].Value = model.PRD002;
parameters [2].Value = model.PRD003;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// 启用或弃用
/// </summary>
/// <param name="oddNum"></param>
/// <returns></returns>
public bool Examine(LineProductMesEntityu.ProductPlanHeaderEntity _header, DataTable tableView)
{
return(dal.Examine(_header, tableView));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table, List <string> idxList)
{
return(dal.Edit(model, table, idxList));
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <returns></returns>
public bool Save(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table)
{
return(dal.Save(model, table));
}
/// <summary>
/// 编辑数据
/// </summary>
/// <param name="model"></param>
/// <param name="table"></param>
/// <param name="idxList"></param>
/// <returns></returns>
public bool Edit(LineProductMesEntityu.ProductPlanHeaderEntity model, DataTable table, List <string> idxList)
{
Dictionary <object, object> SQLString = new Dictionary <object, object> ( );
LineProductMesEntityu.ProductPlanBodyEntity modelBody = new LineProductMesEntityu.ProductPlanBodyEntity( );
modelBody.PRE001 = model.PRD001;
//StringBuilder strSql = new StringBuilder ( );
//strSql . Append ( "SELECT PRF001,PRF002 FROM MIKPRF " );
//DataTable tableR = SqlHelper . ExecuteDataTable ( strSql . ToString ( ) );
foreach (DataRow row in table.Rows)
{
modelBody.idx = string.IsNullOrEmpty(row ["idx"].ToString( )) == true ? 0 : Convert.ToInt32(row ["idx"]);
modelBody.PRE002 = row ["PRE002"].ToString( );
modelBody.PRE003 = row ["PRE003"].ToString( );
modelBody.PRE004 = row ["PRE004"].ToString( );
modelBody.PRE005 = Convert.ToDateTime(row ["PRE005"].ToString( ));
modelBody.PRE006 = Convert.ToDateTime(row ["PRE006"].ToString( ));
modelBody.PRE007 = Convert.ToInt32(row ["PRE007"].ToString( ));
modelBody.PRE008 = string.IsNullOrEmpty(row ["PRE008"].ToString( )) == true ? 0 : Convert.ToInt32(row ["PRE008"].ToString( ));
//modelBody . PRE009 = string . IsNullOrEmpty ( row [ "PRE009" ] . ToString ( ) ) == true ? 0 : Convert . ToInt32 ( row [ "PRE009" ] . ToString ( ) );
modelBody.PRE010 = Convert.ToInt32(row ["PRE010"].ToString( ));
//modelBody . PRE012 = modelBody . PRE009 == 0 ? string . Empty : row [ "PRE012" ] . ToString ( );
if (string.IsNullOrEmpty(row ["PRE011"].ToString( )))
{
modelBody.PRE011 = 0;
}
else
{
modelBody.PRE011 = Convert.ToInt32(row ["PRE011"].ToString( ));
}
modelBody.PRE008 = modelBody.PRE008 + modelBody.PRE011;
if (modelBody.idx < 1)
{
AddBody(SQLString, modelBody);
//if ( tableR != null && tableR . Rows . Count > 0 )
//{
// if ( tableR . Select ( "PRF001='" + modelBody . PRE004 + "' AND PRF002='" + modelBody . PRE005 + "'" ) . Length < 1 )
// Addprf ( SQLString ,modelBody );
// else
// {
// if ( modelBody . PRE011 != 0 )
// {
// modelBody . PRE008 = modelBody . PRE011;
// Editprf ( SQLString ,modelBody );
// }
// }
//}
//else
// Addprf ( SQLString ,modelBody );
}
else
{
EditBody(SQLString, modelBody);
//if ( modelBody . PRE011 != 0 )
//{
// modelBody . PRE008 = modelBody . PRE011;
// Editprf ( SQLString ,modelBody );
//}
}
}
foreach (string s in idxList)
{
DeleteBody(SQLString, s);
}
return(SqlHelper.ExecuteSqlTranDic(SQLString));
}
