public static AsmStationObject GetStationByCondition(string sql)
{
AsmStationObject aso = null;
string sl = "SELECT STATION_ID,STATION_INDEX,STATION_NAME,STATION_PROCESSOK,STATION_DATAOK,STATION_TYPE,STATION_RECIPEORNOT,STATION_AGVORNOT,STATION_REQUSTOUTLINE,STATION_LIGHTORNOT,STATION_REQUSTIN,STATION_REVIEWORNOT,STATION_PRINTORNOT,STATION_UPLOADMES,STATION_ENDORNOT,STATION_GUNORNOT,STATION_TIME,STATION_AUTOORNOT FROM dbo.C_ASM_STATION_T WHERE " + sql;
DataTable dt = new DataTable();
dt = ClsCommon.dbSql.ExecuteDataTable(sl);
if (dt.Rows.Count > 0)
{
aso = new AsmStationObject();
aso.STATION_ID = Convert.ToInt32(dt.Rows[0]["STATION_ID"].ToString());
aso.STATION_INDEX = dt.Rows[0]["STATION_INDEX"].ToString();
aso.STATION_NAME = dt.Rows[0]["STATION_NAME"].ToString();
aso.STATION_PROCESSOK = dt.Rows[0]["STATION_PROCESSOK"].ToString();
aso.STATION_DATAOK = dt.Rows[0]["STATION_DATAOK"].ToString();
aso.STATION_TYPE = dt.Rows[0]["STATION_TYPE"].ToString();
aso.STATION_RECIPEORNOT = dt.Rows[0]["STATION_RECIPEORNOT"].ToString();
aso.STATION_AGVORNOT = dt.Rows[0]["STATION_AGVORNOT"].ToString();
aso.STATION_REQUSTOUTLINE = dt.Rows[0]["STATION_REQUSTOUTLINE"].ToString();
aso.STATION_LIGHTORNOT = dt.Rows[0]["STATION_LIGHTORNOT"].ToString();
aso.STATION_REQUSTIN = dt.Rows[0]["STATION_REQUSTIN"].ToString();
aso.STATION_REVIEWORNOT = dt.Rows[0]["STATION_REVIEWORNOT"].ToString();
aso.STATION_PRINTORNOT = dt.Rows[0]["STATION_PRINTORNOT"].ToString();
aso.STATION_UPLOADMES = dt.Rows[0]["STATION_UPLOADMES"].ToString();
aso.STATION_ENDORNOT = dt.Rows[0]["STATION_ENDORNOT"].ToString();
aso.STATION_GUNORNOT = dt.Rows[0]["STATION_GUNORNOT"].ToString();
aso.STATION_TIME = Convert.ToInt32(dt.Rows[0]["STATION_TIME"].ToString());
aso.STATION_AUTOORNOT = dt.Rows[0]["STATION_AUTOORNOT"].ToString();
}
return(aso);
}
public static int AddStationByObject(AsmStationObject aso)
{
using (IDbConnection conn = ClsCommon.OpenConnection()) //这里访问的是Sqlite数据文件，这里OpenConnection即上边获取连接数据库对象方法
{
var result = conn.Insert(aso);
return(Convert.ToInt32(result));
}
}
public static int UpdateStationByObject(AsmStationObject aso)
{
var result = 0;
using (IDbConnection conn = ClsCommon.OpenConnection()) //这里访问的是Sqlite数据文件，这里OpenConnection即上边获取连接数据库对象方法
{
result = conn.Update(aso);
}
return(Convert.ToInt32(result));
}
public static int DeleteStationByCondition(string sql)
{
int a = 0;
AsmStationObject aso = GetStationByCondition(sql);
if (aso != null)
{
string sl = "DELETE FROM dbo.C_ASM_STATION_T WHERE " + sql;
a = ClsCommon.dbSql.ExecuteNonQuery(sl);
}
return(a);
}
/// <summary>
/// 工位属性配置
/// </summary>
/// <param name="sql"></param>
public void StationConfigure(string sql)
{
try
{
string str_station = "";
AsmStationObject aso = AsmStation_BLL.GetStationByCondition(sql);
if (aso != null)
{
str_station += "站名： " + aso.STATION_NAME + "\n\n";
str_station += "站类型： " + aso.STATION_TYPE + "\n\n";
str_station += "是否需要配方： " + ((aso.STATION_RECIPEORNOT == "1") ? true : false) + "\n\n";
str_station += "是否配备AGV： " + ((aso.STATION_AGVORNOT == "1") ? true : false) + "\n\n";
str_station += "是否点亮放行灯：" + ((aso.STATION_LIGHTORNOT == "1") ? true : false) + "\n\n";
str_station += "是否配置打印机：" + ((aso.STATION_PRINTORNOT == "1") ? true : false) + "\n\n";
str_station += "是否末站： " + ((aso.STATION_ENDORNOT == "1") ? true : false) + "\n\n";
str_station += "是否配备拧紧枪：" + ((aso.STATION_GUNORNOT == "1") ? true : false) + "\n\n";
str_station += "工位节拍： " + aso.STATION_TIME + "\n\n";
}
rTB_stationproperty.AppendText(str_station);
}
catch (Exception e)
{
}
}
public static AsmStationObject GetStationByCondition(string sql)
{
AsmStationObject aso = AsmStation_DAL.GetStationByCondition(sql);
return(aso);
}
public static int UpdateStationByObject(AsmStationObject aso)
{
int a = AsmStation_DAL.UpdateStationByObject(aso);
return(a);
}
public static int AddStationByObject(AsmStationObject aso)
{
int a = AsmStation_DAL.AddStationByObject(aso);
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)
{
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
int index = 0;
string stName;
XmlNode lineNode = ClsCommon.InfoRootNode.SelectSingleNode("line[@name='" + lineName + "']");
XmlNodeList stationNodes = lineNode.SelectNodes("station");///////DELETE
foreach (XmlNode node in stationNodes)
{
if (int.Parse(node.Attributes["index"].Value) > index)
{
index = int.Parse(node.Attributes["index"].Value);
}
}
if (lstStation.Items.Count > 0)
{
index++;
}
stName = "Station" + index.ToString();
XmlElement element = ClsCommon.xml.CreateElement("station");
element.SetAttribute("index", index.ToString());
element.SetAttribute("name", stName);
element.SetAttribute("processOK", "0");
element.SetAttribute("dataOK", "0");
//element.SetAttribute("index", index.ToString());
//element.SetAttribute("name", stName);
//element.SetAttribute("scanValue", "");
//element.SetAttribute("automaticStation", "0");
element.SetAttribute("type", "0");
element.SetAttribute("recipeOrNot", "1");
element.SetAttribute("agvOrNot", "1");
element.SetAttribute("requentMESoutLineOrNot", "0");
element.SetAttribute("lightLighOrNot", "0");
element.SetAttribute("requentMESInLineOrNot", "0");
element.SetAttribute("reviewOrNot", "1");
element.SetAttribute("printOrNot", "0");
element.SetAttribute("dataUploadMESOrNot", "0");
element.SetAttribute("endSTorNot", "0");
element.SetAttribute("gunOrNot", "1");
element.SetAttribute("autoOrNot", "0");
element.SetAttribute("stationTime", "10000");
//element.SetAttribute("keypartOK", "0");
//element.SetAttribute("statusOK", "0");
//element.SetAttribute("processOK", "0");
// element.SetAttribute("dataOK", "0");
//element.SetAttribute("snAddr", "");
//element.SetAttribute("snTagAddr", "");
//element.SetAttribute("okAddr", "");
//element.SetAttribute("programAddr", "");
//element.SetAttribute("enableAddr", "");
//element.SetAttribute("enableTagAddr", "");
lineNode.AppendChild(element);
ClsCommon.saveXml();
#region >>>>>同步新增站
AsmStationObject aso = new AsmStationObject();
aso.STATION_INDEX = index.ToString();
aso.STATION_NAME = stName;
aso.STATION_PROCESSOK = "0";
aso.STATION_DATAOK = "0";
aso.STATION_TYPE = "0";
aso.STATION_RECIPEORNOT = "1";
aso.STATION_AGVORNOT = "1";
aso.STATION_REQUSTOUTLINE = "1";
aso.STATION_LIGHTORNOT = "1";
aso.STATION_REQUSTIN = "1";
aso.STATION_REVIEWORNOT = "1";
aso.STATION_PRINTORNOT = "1";
aso.STATION_UPLOADMES = "1";
aso.STATION_ENDORNOT = "0";
aso.STATION_GUNORNOT = "1";
aso.STATION_AUTOORNOT = "0";
aso.STATION_TIME = 10000;
AsmStation_BLL.AddStationByObject(aso);
#endregion
lstStation.Items.Add(stName);
lstStation.SelectedIndex = lstStation.Items.Count - 1;
if (lstStation.Items.Count > 0)
{
btnRemove.Enabled = true;
btnMovedown.Enabled = true;
btnMoveup.Enabled = true;
}
}
public void Refish()
{
aso = AsmStation_BLL.GetStationByCondition(" STATION_NAME='" + StationName + "';");
}
