/// <summary>
/// add srt
/// </summary>
/// <param name="SQLString"></param>
/// <param name="strSql"></param>
/// <param name="_model"></param>
void add_SRT(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.SingRowTableSRTEntity model)
{
strSql = new StringBuilder( );
strSql.Append("INSERT INTO MOXSRT (");
strSql.Append("SRT001,SRT002,SRT003,SRT004,SRT005,SRT006,SRT007,SRT008,SRT009,SRT010) ");
strSql.Append("VALUES (");
strSql.Append("@SRT001,@SRT002,@SRT003,@SRT004,@SRT005,@SRT006,@SRT007,@SRT008,@SRT009,@SRT010) ");
SqlParameter [] parameters =
{
new SqlParameter("@SRT001", SqlDbType.NVarChar, 50),
new SqlParameter("@SRT002", SqlDbType.NVarChar, 50),
new SqlParameter("@SRT003", SqlDbType.NVarChar, 50),
new SqlParameter("@SRT004", SqlDbType.NVarChar, 50),
new SqlParameter("@SRT005", SqlDbType.NVarChar, 50),
new SqlParameter("@SRT006", SqlDbType.Int, 4),
new SqlParameter("@SRT007", SqlDbType.VarChar, 50),
new SqlParameter("@SRT008", SqlDbType.VarChar, 50),
new SqlParameter("@SRT009", SqlDbType.VarChar, 50),
new SqlParameter("@SRT010", SqlDbType.VarChar, 100)
};
parameters [0].Value = model.SRT001;
parameters [1].Value = model.SRT002;
parameters [2].Value = model.SRT003;
parameters [3].Value = model.SRT004;
parameters [4].Value = model.SRT005;
parameters [5].Value = 1;
parameters [6].Value = model.SRT007;
parameters [7].Value = model.SRT008;
parameters [8].Value = model.SRT009;
parameters [9].Value = model.SRT010;
SQLString.Add(strSql, parameters);
}
/// <summary>
/// edit sign to sgmraa
/// </summary>
/// <param name="SQLString"></param>
/// <param name="strSql"></param>
/// <param name="model"></param>
void edit_raa(Hashtable SQLString, StringBuilder strSql, ProductionErpEntity.SingRowTableSRTEntity model)
{
strSql = new StringBuilder( );
strSql.Append("UPDATE SGMRAA SET ");
strSql.Append("RAA032='T' ");
strSql.AppendFormat("WHERE RAA001='{0}'", model.SRT002);
SQLString.Add(strSql, null);
}
/// <summary>
/// save data to srt
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public bool GenerMOXSRT(DataTable table, List <string> idxList)
{
ProductionErpEntity.SingRowTableSRTEntity _model = new ProductionErpEntity.SingRowTableSRTEntity( );
Hashtable SQLString = new Hashtable( );
StringBuilder strSql = new StringBuilder( );
Hashtable strList = new Hashtable( );
int checkOne = 0, checkTwo = 0, checkTre = 0;
_model.SRT001 = getOddNum_SRT( );
for (int i = 0; i < table.Rows.Count; i++)
{
checkOne = string.IsNullOrEmpty(table.Rows [i] ["checkOne"].ToString( )) == true ? 0 : ( int )table.Rows [i] ["checkOne"];
checkTwo = string.IsNullOrEmpty(table.Rows [i] ["checkTwo"].ToString( )) == true ? 0 : ( int )table.Rows [i] ["checkTwo"];
checkTre = string.IsNullOrEmpty(table.Rows [i] ["checkTre"].ToString( )) == true ? 0 : ( int )table.Rows [i] ["checkTre"];
_model.SRT002 = table.Rows [i] ["RAA001"].ToString( );
_model.SRT003 = table.Rows [i] ["RAA015"].ToString( );
if (idxList.Contains(_model.SRT002 + _model.SRT003))
{
_model.SRT006 = string.IsNullOrEmpty(table.Rows [i] ["RAA018"].ToString( )) == true ? 0 : Convert.ToInt32(table.Rows [i] ["RAA018"].ToString( ));
_model.SRT006 = Exists_SRT(_model);
if (_model.SRT006 > 0)
{
_model.SRT004 = table.Rows [i] ["DEA002"].ToString( );
_model.SRT005 = table.Rows [i] ["DEA057"].ToString( );
_model.SRT007 = _model.SRT008 = _model.SRT009 = string.Empty;
_model.SRT010 = table.Rows [i] ["RAA021"].ToString( );
for (int k = 0; k < _model.SRT006; k++)
{
if (checkOne == 1)
{
_model.SRT007 = "000" + codeNum_SRT(_model.SRT003, table.Rows [i] ["DEA004"].ToString( ), strList, "SRT007");
}
if (checkTwo == 1)
{
_model.SRT008 = "000" + codeNum_SRT(_model.SRT003, table.Rows [i] ["DEA004"].ToString( ), strList, "SRT008");
}
if (checkTre == 1)
{
_model.SRT009 = "000" + codeNum_SRT(_model.SRT003, table.Rows [i] ["DEA004"].ToString( ), strList, "SRT009");
}
add_SRT(SQLString, strSql, _model);
}
edit_raa(SQLString, strSql, _model);
}
}
}
return(SqlHelper.ExecuteSqlTran(SQLString));
}
/// <summary>
/// does it exists job number and product num
/// </summary>
/// <param name="_model"></param>
/// <returns></returns>
int Exists_SRT(ProductionErpEntity.SingRowTableSRTEntity _model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("SELECT {0}-COUNT(1) COUN FROM MOXSRT ", _model.SRT006);
strSql.AppendFormat("WHERE SRT002='{0}' AND SRT003='{1}'", _model.SRT002, _model.SRT003);
//strSql . AppendFormat ( "WHERE SRT003='{0}'" ,_model . SRT003 );
DataTable da = SqlHelper.ExecuteDataTable(strSql.ToString( ));
if (da != null && da.Rows.Count > 0)
{
return(string.IsNullOrEmpty(da.Rows [0] ["COUN"].ToString( )) == true ? 0 : Convert.ToInt32(da.Rows [0] ["COUN"].ToString( )));
}
else
{
return(0);
}
}
public FormSingRowTable( )
{
InitializeComponent( );
_bll = new ProductionErpBll.Bll.SingRowTableBll( );
model = new ProductionErpEntity.SingRowTableSRTEntity( );
Utility.GridViewMoHuSelect.SetFilter(gridView1);
FieldInfo fi = typeof(XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic);
fi.SetValue(null, new DrawXPaint( ));
//barMenu . LinksPersistInfo . RemoveAt ( toolExport . Id );
barMenu.LinksPersistInfo.RemoveAt(toolCancel.Id);
barMenu.LinksPersistInfo.RemoveAt(toolSave.Id);
barMenu.LinksPersistInfo.RemoveAt(toolEdit.Id);
barMenu.LinksPersistInfo.RemoveAt(toolAdd.Id);
getColumns( );
}
