public static AsmProductionObject GetAsmProductionByCondition(string sql)
{
AsmProductionObject apo = null;
try
{
string sl = "SELECT PRODUCTION_ID,PRODUCTION_NAME,PRODUCTION_TYPE,PRODUCTION_TRADEMARK,PRODUCTION_SERIES,PRODUCTION_VR,PRODUCTION_DISCRIPTION,PRODUCTION_GT,PRODUCTION_ET,PRODUCTION_STE FROM dbo.C_ASM_PRODUCTION_T WHERE " + sql;
DataTable dt = new DataTable();
dt = ClsCommon.dbSql.ExecuteDataTable(sl);
if (dt.Rows.Count > 0)
{
apo = new AsmProductionObject();
apo.PRODUCTION_ID = Convert.ToInt32(dt.Rows[0]["PRODUCTION_ID"].ToString());
apo.PRODUCTION_NAME = dt.Rows[0]["PRODUCTION_NAME"].ToString();
apo.PRODUCTION_TYPE = dt.Rows[0]["PRODUCTION_TYPE"].ToString();
apo.PRODUCTION_TRADEMARK = dt.Rows[0]["PRODUCTION_TRADEMARK"].ToString();
apo.PRODUCTION_SERIES = dt.Rows[0]["PRODUCTION_SERIES"].ToString();
apo.PRODUCTION_VR = dt.Rows[0]["PRODUCTION_VR"].ToString();
apo.PRODUCTION_DISCRIPTION = dt.Rows[0]["PRODUCTION_DISCRIPTION"].ToString();
apo.PRODUCTION_ET = dt.Rows[0]["PRODUCTION_ET"].ToString();
apo.PRODUCTION_GT = dt.Rows[0]["PRODUCTION_GT"].ToString();
apo.PRODUCTION_STE = dt.Rows[0]["PRODUCTION_STE"].ToString();
}
return(apo);
}
catch (Exception ex)
{
return(apo);
}
}
public static AsmProductionObject GetAsmProductionByCondition(string sql)
{
AsmProductionObject apo = null;
apo = AsmProduction_DAL.GetAsmProductionByCondition(sql);
return(apo);
}
public static int AddAsmProductionByObjectReturnId(AsmProductionObject apo)
{
using (IDbConnection conn = ClsCommon.OpenConnection()) //这里访问的是Sqlite数据文件，这里OpenConnection即上边获取连接数据库对象方法
{
var result = conn.Insert(apo);
return(Convert.ToInt32(result));
}
}
public static int DeleteAamProductionByObject(AsmProductionObject apo)
{
int a = 0;
try
{
string sql = "DELETE FROM dbo.C_ASM_PRODUCTION_T WHERE PRODUCTION_ID=" + apo.PRODUCTION_ID;
a = ClsCommon.dbSql.ExecuteNonQuery(sql);
return(a);
}
catch (Exception ex)
{
return(a);
}
}
public static int UpdateAsmProductionById(AsmProductionObject apo)
{
int a = 0;
try
{
string sql = "UPDATE dbo.C_ASM_PRODUCTION_T SET PRODUCTION_NAME='" + apo.PRODUCTION_NAME + "',PRODUCTION_TYPE='" + apo.PRODUCTION_TYPE + "',PRODUCTION_TRADEMARK='" + apo.PRODUCTION_TRADEMARK + "',PRODUCTION_SERIES='" + apo.PRODUCTION_SERIES + "',PRODUCTION_VR='" + apo.PRODUCTION_VR + "',PRODUCTION_DISCRIPTION='" + apo.PRODUCTION_DISCRIPTION + "',PRODUCTION_ET='" + apo.PRODUCTION_ET + "',PRODUCTION_GT='" + apo.PRODUCTION_GT + "',PRODUCTION_STE='" + apo.PRODUCTION_STE + "' WHERE PRODUCTION_ID=" + apo.PRODUCTION_ID;
a = ClsCommon.dbSql.ExecuteNonQuery(sql);
return(a);
}
catch (Exception ex)
{
return(a);
}
}
public static int AddAsmProductionByObject(AsmProductionObject apo)
{
int a = 0;
try
{
string sql = "INSERT INTO dbo.C_ASM_PRODUCTION_T(PRODUCTION_NAME,PRODUCTION_TYPE,PRODUCTION_TRADEMARK,PRODUCTION_SERIES,PRODUCTION_VR,PRODUCTION_DISCRIPTION,PRODUCTION_ET,PRODUCTION_GT,PRODUCTION_STE)VALUES('" + apo.PRODUCTION_NAME + "','" + apo.PRODUCTION_TYPE + "','" + apo.PRODUCTION_TRADEMARK + "','" + apo.PRODUCTION_SERIES + "','" + apo.PRODUCTION_VR + "','" + apo.PRODUCTION_DISCRIPTION + "','" + apo.PRODUCTION_ET + "','" + apo.PRODUCTION_GT + "','" + apo.PRODUCTION_STE + "');";
a = ClsCommon.dbSql.ExecuteNonQuery(sql);
return(a);
}
catch (Exception ex)
{
return(a);
}
}
/// <summary>
/// 存储数据
/// </summary>
public void StoreData()
{
try
{
List <Item> list_item = addFlow.Items;
DataTable dt = AsmStation_BLL.GetAllStation();
AsmProductionWayRecordObject apwo = null;
AsmProductionWayRecordObject apwo_right = null;
List <string> list = new List <string>();
bool judge = false;
bool judge_right = false;
int j = 1;
List <Item> list_link = new List <Item>();
for (int i = 0; i < list_item.Count; i++)
{
if (list_item[i].GetType().ToString().Contains("Link"))
{
list_link.Add(list_item[i]);
}
}
for (int i = 0; i < list_link.Count; i++)
{
string str_left = (list_link[i] as Link).Org.Text;
string str_right = (list_link[i] as Link).Dst.Text;
if (list.Count > 0)
{
for (int m = 0; m < list.Count; m++)
{
if (str_left.Equals(list[m]))
{
judge = false;
}
else
{
judge = true;
}
}
}
else
{
judge = true;
}
if (judge)
{
apwo = new AsmProductionWayRecordObject();
apwo.ST_NAME = str_left;
AsmProductionObject apo = AsmProduction_BLL.GetAsmProductionByCondition("PRODUCTION_NAME='" + cB_product_name.SelectedItem.ToString() + "'");
if (apo != null)
{
apwo.PRODUCTION_NAME = apo.PRODUCTION_NAME;
apwo.PRODUCTION_ID = apo.PRODUCTION_ID;
}
AsmStationObject aso = AsmStation_BLL.GetStationByCondition("STATION_NAME='" + apwo.ST_NAME + "'");
if (aso != null)
{
apwo.ST_ID = aso.STATION_ID;
}
apwo.DT = System.DateTime.Now;
apwo.SERIAL_NO = j++;
AsmproductionWayRecord_BLL.AddRecord(apwo);
}
if (list.Count > 0)
{
for (int m = 0; m < list.Count; m++)
{
if (str_right.Equals(list[m]))
{
judge_right = false;
}
else
{
judge_right = true;
}
}
}
else
{
judge_right = true;
}
if (judge_right)
{
apwo_right = new AsmProductionWayRecordObject();
apwo_right.ST_NAME = str_right;
AsmProductionObject apoX = AsmProduction_BLL.GetAsmProductionByCondition("PRODUCTION_NAME='" + cB_product_name.SelectedItem.ToString() + "'");
apwo_right.PRODUCTION_NAME = apoX.PRODUCTION_NAME;
apwo_right.PRODUCTION_ID = apoX.PRODUCTION_ID;
AsmStationObject asoX = AsmStation_BLL.GetStationByCondition("STATION_NAME='" + apwo_right.ST_NAME + "'");
apwo_right.ST_ID = asoX.STATION_ID;
apwo_right.DT = System.DateTime.Now;
apwo_right.SERIAL_NO = j++;
AsmproductionWayRecord_BLL.AddRecord(apwo_right);
}
}
DataTable dt_way = AsmProductionWay_BLL.GetWayByCondition("PRODUCTION_NAME= '" + cB_product_name.SelectedItem.ToString().Trim() + "'");
if (!(dt_way.Rows.Count > 0))
{
DataTable dt_record = AsmproductionWayRecord_BLL.GetAllRecordByCondition(cB_product_name.SelectedItem.ToString().Trim());
AsmProductionWayObject apwro = null;
for (int i = 0; i < dt_record.Rows.Count; i++)
{
apwro = new AsmProductionWayObject();
apwro.ST_NAME = dt_record.Rows[i]["ST_NAME"].ToString();
apwro.DT = Convert.ToDateTime(dt_record.Rows[i]["DT"].ToString());
apwro.PRODUCTION_NAME = dt_record.Rows[i]["PRODUCTION_NAME"].ToString();
apwro.PRODUCTION_ID = Convert.ToInt32(dt_record.Rows[i]["PRODUCTION_ID"].ToString());
apwro.ST_NAME = dt_record.Rows[i]["ST_NAME"].ToString();
apwro.ST_ID = Convert.ToInt32(dt_record.Rows[i]["ST_ID"].ToString());
apwro.SERIAL_NO = i + 1;
AsmProductionWay_BLL.AddRoutingRecord(apwro);
}
}
else
{
AsmProductionWay_BLL.DeleteAllByCondition("PRODUCTION_NAME= '" + cB_product_name.SelectedItem.ToString().Trim() + "'");
DataTable dt_record = AsmproductionWayRecord_BLL.GetAllRecordByCondition(cB_product_name.SelectedItem.ToString().Trim());
AsmProductionWayObject apwro = null;
for (int i = 0; i < dt_record.Rows.Count; i++)
{
apwro = new AsmProductionWayObject();
apwro.DT = Convert.ToDateTime(dt_record.Rows[i]["DT"]);
apwro.PRODUCTION_NAME = dt_record.Rows[i]["PRODUCTION_NAME"].ToString();
apwro.PRODUCTION_ID = Convert.ToInt32(dt_record.Rows[i]["PRODUCTION_ID"].ToString());
apwro.ST_NAME = dt_record.Rows[i]["ST_NAME"].ToString();
apwro.ST_ID = Convert.ToInt32(dt_record.Rows[i]["ST_ID"].ToString());
apwro.SERIAL_NO = i + 1;
AsmProductionWay_BLL.AddRoutingRecord(apwro);
}
}
}
catch (Exception)
{
}
}
public static int DeleteAamProductionById(AsmProductionObject apo)
{
int a = AsmProduction_DAL.DeleteAamProductionByObject(apo);
return(a);
}
public static int UpdateAsmProductionById(AsmProductionObject apo)
{
int a = AsmProduction_DAL.UpdateAsmProductionById(apo);
return(a);
}
public static int AddAsmProductionByObject(AsmProductionObject apo)
{
int a = AsmProduction_DAL.AddAsmProductionByObject(apo);
return(a);
}
public static int AddAsmProductionByObjectReturnId(AsmProductionObject apo)
{
int id = AsmProduction_DAL.AddAsmProductionByObjectReturnId(apo);
return(id);
}
private void BT_S_Click(object sender, EventArgs e)
{
AsmProductionObject apo = null;
if (!String.IsNullOrEmpty(TB_PN.Text.Trim()) && !String.IsNullOrEmpty(TB_PT.Text.Trim()))
{
apo = AsmProduction_BLL.GetAsmProductionByCondition(" PRODUCTION_TYPE= '" + TB_PT.Text.Trim() + "' AND PRODUCTION_NAME='" + TB_PN.Text.Trim() + "' AND PRODUCTION_VR='" + TB_VR.Text.Trim() + "'");
if (apo != null)
{
apo.PRODUCTION_NAME = TB_PN.Text.Trim();
apo.PRODUCTION_TYPE = TB_PT.Text.Trim();
apo.PRODUCTION_SERIES = TB_PS.Text.Trim();
apo.PRODUCTION_TRADEMARK = TB_PTR.Text.Trim();
apo.PRODUCTION_VR = TB_VR.Text.Trim();
apo.PRODUCTION_DISCRIPTION = TB_PD.Text.Trim();
if (CB_Online.Checked)
{
apo.PRODUCTION_STE = "1";//在线模式
}
if (CB_Offline.Checked)
{
apo.PRODUCTION_STE = "2";//离线模式
}
// apo.PRODUCTION_GT = TB_GT.Text.Trim();
if (AsmProduction_BLL.UpdateAsmProductionById(apo) > 0)
{
MessageBox.Show("更新产品信息成功......");
TB_PN.Text = "";
TB_PT.Text = "";
TB_PS.Text = "";
TB_VR.Text = "";
TB_PD.Text = "";
CB_Online.Checked = true;
// TB_ET.Text = "";
// TB_GT.Text = "";
PL_D.Visible = false;
DataBind();
}
else
{
MessageBox.Show("更新产品信息失败......");
}
}
else
{
apo = new AsmProductionObject();
apo.PRODUCTION_NAME = TB_PN.Text.Trim();
apo.PRODUCTION_TYPE = TB_PT.Text.Trim();
apo.PRODUCTION_SERIES = TB_PS.Text.Trim();
apo.PRODUCTION_TRADEMARK = TB_PTR.Text.Trim();
apo.PRODUCTION_VR = TB_VR.Text.Trim();
apo.PRODUCTION_DISCRIPTION = TB_PD.Text.Trim();
if (CB_Online.Checked)
{
apo.PRODUCTION_STE = "1";//在线模式
}
if (CB_Offline.Checked)
{
apo.PRODUCTION_STE = "2";//离线模式
}
// apo.PRODUCTION_GT = TB_GT.Text.Trim();
if (AsmProduction_BLL.AddAsmProductionByObject(apo) > 0)
{
TB_PN.Text = "";
TB_PT.Text = "";
TB_PS.Text = "";
TB_VR.Text = "";
TB_PD.Text = "";
CB_Online.Checked = true;
// TB_GT.Text = "";
PL_D.Visible = false;
DataBind();
MessageBox.Show("添加产品信息成功......");
}
else
{
MessageBox.Show("添加产品信息失败......");
}
}
}
else
{
MessageBox.Show("输入产品信息不全.....");
}
}
