//
//TreeView 双击事件
//
private void trv_FixtureView_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
PropertyNodeItem t = (PropertyNodeItem)trv_FixtureView.SelectedItem;
_W_FixtureInfo = t.Fixture;
ShowFixture(t.Fixture);
}
//
//双击查找的治具
//
private void dgv_FixInfo_List_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
Clear_Control(true);
_W_FixtureInfo = (Maticsoft.Model.FixtureInfo)dgv_FixInfo_List.SelectedItem;
FixtrueInfo = GetFixInfoList(_W_FixtureInfo);
Lading_FixtureViws();
}
//
//双击FixtureInfo
//
private void dgv_FixtureInfo_MouseDoubleClick(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
frm_Fixture f = new frm_Fixture();
Maticsoft.Model.FixtureInfo _fix = (Maticsoft.Model.FixtureInfo)dgv_FixtureInfo.SelectedItem;
f.FixtrueInfo = FixList(_fix);
f.Lading_FixtureViws();
f.Show();
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.FixtureInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_FixtureInfo(");
strSql.Append("Assembly_BarCode,Assembly_Name,BarCode,Name,Alias,Makedev,Model,FunctionRemarks,SafeCount,Unit,Versions,Up_ID,DrawingPatch,Pic_ID,Correlation_ID,Remarks)");
strSql.Append(" values (");
strSql.Append("@Assembly_BarCode,@Assembly_Name,@BarCode,@Name,@Alias,@Makedev,@Model,@FunctionRemarks,@SafeCount,@Unit,@Versions,@Up_ID,@DrawingPatch,@Pic_ID,@Correlation_ID,@Remarks)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Assembly_BarCode", SqlDbType.VarChar, 50),
new SqlParameter("@Assembly_Name", SqlDbType.VarChar, 50),
new SqlParameter("@BarCode", SqlDbType.VarChar, 50),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Alias", SqlDbType.VarChar, 50),
new SqlParameter("@Makedev", SqlDbType.VarChar, 50),
new SqlParameter("@Model", SqlDbType.VarChar, 50),
new SqlParameter("@FunctionRemarks", SqlDbType.VarChar, 255),
new SqlParameter("@SafeCount", SqlDbType.VarChar, 50),
new SqlParameter("@Unit", SqlDbType.VarChar, 50),
new SqlParameter("@Versions", SqlDbType.VarChar, 50),
new SqlParameter("@Up_ID", SqlDbType.VarChar, 50),
new SqlParameter("@DrawingPatch", SqlDbType.VarChar, 255),
new SqlParameter("@Pic_ID", SqlDbType.VarChar, 50),
new SqlParameter("@Correlation_ID", SqlDbType.VarChar, 50),
new SqlParameter("@Remarks", SqlDbType.VarChar, 255)
};
parameters[0].Value = model.Assembly_BarCode;
parameters[1].Value = model.Assembly_Name;
parameters[2].Value = model.BarCode;
parameters[3].Value = model.Name;
parameters[4].Value = model.Alias;
parameters[5].Value = model.Makedev;
parameters[6].Value = model.Model;
parameters[7].Value = model.FunctionRemarks;
parameters[8].Value = model.SafeCount;
parameters[9].Value = model.Unit;
parameters[10].Value = model.Versions;
parameters[11].Value = model.Up_ID;
parameters[12].Value = model.DrawingPatch;
parameters[13].Value = model.Pic_ID;
parameters[14].Value = model.Correlation_ID;
parameters[15].Value = model.Remarks;
object obj = dbs.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
//
//选择总成
//
private void dgv_FixtureInfo_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)
{
try
{
Maticsoft.Model.FixtureInfo _fixtureInfo = (Maticsoft.Model.FixtureInfo)dgv_FixtureInfo.SelectedItem;
txb_AssetNumber.Text = _fixtureInfo.Assembly_BarCode;
txb_AssetName.Text = _fixtureInfo.Assembly_Name;
}
catch { }
}
/// <summary>
/// 获取治具总表中的治具列表
/// </summary>
/// <param name="_Fix"></param>
/// <returns></returns>
private ArrayList FixList(Maticsoft.Model.FixtureInfo _Fix)
{
ArrayList tem = new ArrayList();
foreach (object fix in MCP_CS.FixtureInfo.GetModelList("(Assembly_BarCode = '" + _Fix.Assembly_BarCode + "')"))
{
tem.Add(fix);
}
return(tem);
}
/// <summary>
/// 加载治具视图
/// </summary>
public void Lading_FixtureViws()
{
if (FixtrueInfo.Count > 0)
{
Maticsoft.Model.FixtureInfo _TemFixtureInfo = (Maticsoft.Model.FixtureInfo)FixtrueInfo[0];
if (FixtrueInfo.Count == 1) //如果只有一个总成
{
//治具总名称
PropertyNodeItem node1 = new PropertyNodeItem()
{
DisplayName = _TemFixtureInfo.Assembly_Name,
Name = "总成名称",
Icon = TAG_ICON,
Fixture = _TemFixtureInfo
};
itemList.Add(node1);
}
else //如果总成下面有很多的治具
{
//治具总名称
PropertyNodeItem node1 = new PropertyNodeItem()
{
DisplayName = _TemFixtureInfo.Assembly_Name,
Name = "总成名称",
Icon = TAG_ICON,
Fixture = _TemFixtureInfo
};
foreach (object Fixture in FixtrueInfo)
{
Maticsoft.Model.FixtureInfo _tem = (Maticsoft.Model.FixtureInfo)Fixture;
PropertyNodeItem node1tag1 = new PropertyNodeItem()
{
DisplayName = _tem.Name,
Name = _tem.BarCode,
Icon = TAG_ICON,
Fixture = _tem
};
node1.Children.Add(node1tag1);
}
itemList.Clear();
itemList.Add(node1);
SetControl_IsEn(false, false);
}
}
else
{
My_MessageBox.My_MessageBox_Message("未找到治具信息！");
}
}
//
//保存更新
//
private void btn_Save_Click(object sender, RoutedEventArgs e)
{
if (Is_Add)
{
_W_FixtureInfo = MCP_CS.FixtureInfo.GetModel(MCP_CS.FixtureInfo.Add(GetModel()));
FixtrueInfo = GetFixInfoList(_W_FixtureInfo);
Lading_FixtureViws();
}
else
{
GetModel(_W_FixtureInfo);
MCP_CS.FixtureInfo.Update(_W_FixtureInfo);
Lading_FixtureViws();
}
}
/// <summary>
/// 返回Fix 用于更新
/// </summary>
/// <param name="_TemFixture"></param>
/// <returns></returns>
private Maticsoft.Model.FixtureInfo GetModel(Maticsoft.Model.FixtureInfo _TemFixture)
{
_TemFixture.Assembly_BarCode = txb_AssetNumber.Text.Trim();
_TemFixture.Assembly_Name = txb_Assrt_Name.Text.Trim();
_TemFixture.BarCode = txb_BarCode.Text.Trim();
_TemFixture.Name = txb_Name.Text.Trim();
_TemFixture.Alias = txb_AliasName.Text.Trim();
_TemFixture.FunctionRemarks = txb_FunctionRemarks.Text.Trim();
_TemFixture.Model = txb_Model.Text.Trim();
_TemFixture.Correlation_ID = txb_Correlation.Text.Trim();
_TemFixture.SafeCount = txb_SafeCount.Text.Trim();
_TemFixture.Unit = cmb_Unit.Text.Trim();
_TemFixture.Versions = cmb_Versions.Text.Trim();
_TemFixture.DrawingPatch = txb_DrawingPatch.Text.Trim();
_TemFixture.Pic_ID = txb_PicID.Text.Trim();
return(_TemFixture);
}
/// <summary>
/// 显示治具的信息
/// </summary>
/// <param name="?"></param>
private void ShowFixture(Maticsoft.Model.FixtureInfo _Fix)
{
if (_Fix != null)
{
txb_Assrt_Name.Text = _Fix.Assembly_Name;
txb_AssetNumber.Text = _Fix.Assembly_BarCode;
txb_BarCode.Text = _Fix.BarCode;
txb_Name.Text = _Fix.Name;
txb_AliasName.Text = _Fix.Alias;
txb_Model.Text = _Fix.Model;
txb_FunctionRemarks.Text = _Fix.FunctionRemarks;
txb_Correlation.Text = _Fix.Correlation_ID;
txb_SafeCount.Text = _Fix.SafeCount;
cmb_Unit.Text = _Fix.Unit;
cmb_Versions.Text = _Fix.Versions;
txb_DrawingPatch.Text = _Fix.DrawingPatch;
txb_PicID.Text = _Fix.Pic_ID;
}
else
{
My_MessageBox.My_MessageBox_Message("未找到此治具信息！");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.FixtureInfo GetModel(string _AssetNumber)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 FAY_ID,Assembly_BarCode,Assembly_Name,BarCode,Name,Alias,Makedev,Model,FunctionRemarks,SafeCount,Unit,Versions,Up_ID,DrawingPatch,Pic_ID,Correlation_ID,Remarks from tb_FixtureInfo ");
strSql.Append(" where Assembly_BarCode=@Assembly_BarCode");
SqlParameter[] parameters =
{
new SqlParameter("@Assembly_BarCode", SqlDbType.VarChar, 50)
};
parameters[0].Value = _AssetNumber;
Maticsoft.Model.FixtureInfo model = new Maticsoft.Model.FixtureInfo();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["FAY_ID"] != null && ds.Tables[0].Rows[0]["FAY_ID"].ToString() != "")
{
model.FAY_ID = decimal.Parse(ds.Tables[0].Rows[0]["FAY_ID"].ToString());
}
if (ds.Tables[0].Rows[0]["Assembly_BarCode"] != null && ds.Tables[0].Rows[0]["Assembly_BarCode"].ToString() != "")
{
model.Assembly_BarCode = ds.Tables[0].Rows[0]["Assembly_BarCode"].ToString();
}
if (ds.Tables[0].Rows[0]["Assembly_Name"] != null && ds.Tables[0].Rows[0]["Assembly_Name"].ToString() != "")
{
model.Assembly_Name = ds.Tables[0].Rows[0]["Assembly_Name"].ToString();
}
if (ds.Tables[0].Rows[0]["BarCode"] != null && ds.Tables[0].Rows[0]["BarCode"].ToString() != "")
{
model.BarCode = ds.Tables[0].Rows[0]["BarCode"].ToString();
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
model.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["Alias"] != null && ds.Tables[0].Rows[0]["Alias"].ToString() != "")
{
model.Alias = ds.Tables[0].Rows[0]["Alias"].ToString();
}
if (ds.Tables[0].Rows[0]["Makedev"] != null && ds.Tables[0].Rows[0]["Makedev"].ToString() != "")
{
model.Makedev = ds.Tables[0].Rows[0]["Makedev"].ToString();
}
if (ds.Tables[0].Rows[0]["Model"] != null && ds.Tables[0].Rows[0]["Model"].ToString() != "")
{
model.Model = ds.Tables[0].Rows[0]["Model"].ToString();
}
if (ds.Tables[0].Rows[0]["FunctionRemarks"] != null && ds.Tables[0].Rows[0]["FunctionRemarks"].ToString() != "")
{
model.FunctionRemarks = ds.Tables[0].Rows[0]["FunctionRemarks"].ToString();
}
if (ds.Tables[0].Rows[0]["SafeCount"] != null && ds.Tables[0].Rows[0]["SafeCount"].ToString() != "")
{
model.SafeCount = ds.Tables[0].Rows[0]["SafeCount"].ToString();
}
if (ds.Tables[0].Rows[0]["Unit"] != null && ds.Tables[0].Rows[0]["Unit"].ToString() != "")
{
model.Unit = ds.Tables[0].Rows[0]["Unit"].ToString();
}
if (ds.Tables[0].Rows[0]["Versions"] != null && ds.Tables[0].Rows[0]["Versions"].ToString() != "")
{
model.Versions = ds.Tables[0].Rows[0]["Versions"].ToString();
}
if (ds.Tables[0].Rows[0]["Up_ID"] != null && ds.Tables[0].Rows[0]["Up_ID"].ToString() != "")
{
model.Up_ID = ds.Tables[0].Rows[0]["Up_ID"].ToString();
}
if (ds.Tables[0].Rows[0]["DrawingPatch"] != null && ds.Tables[0].Rows[0]["DrawingPatch"].ToString() != "")
{
model.DrawingPatch = ds.Tables[0].Rows[0]["DrawingPatch"].ToString();
}
if (ds.Tables[0].Rows[0]["Pic_ID"] != null && ds.Tables[0].Rows[0]["Pic_ID"].ToString() != "")
{
model.Pic_ID = ds.Tables[0].Rows[0]["Pic_ID"].ToString();
}
if (ds.Tables[0].Rows[0]["Correlation_ID"] != null && ds.Tables[0].Rows[0]["Correlation_ID"].ToString() != "")
{
model.Correlation_ID = ds.Tables[0].Rows[0]["Correlation_ID"].ToString();
}
if (ds.Tables[0].Rows[0]["Remarks"] != null && ds.Tables[0].Rows[0]["Remarks"].ToString() != "")
{
model.Remarks = ds.Tables[0].Rows[0]["Remarks"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.FixtureInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_FixtureInfo set ");
strSql.Append("Assembly_BarCode=@Assembly_BarCode,");
strSql.Append("Assembly_Name=@Assembly_Name,");
strSql.Append("BarCode=@BarCode,");
strSql.Append("Name=@Name,");
strSql.Append("Alias=@Alias,");
strSql.Append("Makedev=@Makedev,");
strSql.Append("Model=@Model,");
strSql.Append("FunctionRemarks=@FunctionRemarks,");
strSql.Append("SafeCount=@SafeCount,");
strSql.Append("Unit=@Unit,");
strSql.Append("Versions=@Versions,");
strSql.Append("Up_ID=@Up_ID,");
strSql.Append("DrawingPatch=@DrawingPatch,");
strSql.Append("Pic_ID=@Pic_ID,");
strSql.Append("Correlation_ID=@Correlation_ID,");
strSql.Append("Remarks=@Remarks");
strSql.Append(" where FAY_ID=@FAY_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Assembly_BarCode", SqlDbType.VarChar, 50),
new SqlParameter("@Assembly_Name", SqlDbType.VarChar, 50),
new SqlParameter("@BarCode", SqlDbType.VarChar, 50),
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@Alias", SqlDbType.VarChar, 50),
new SqlParameter("@Makedev", SqlDbType.VarChar, 50),
new SqlParameter("@Model", SqlDbType.VarChar, 50),
new SqlParameter("@FunctionRemarks", SqlDbType.VarChar, 255),
new SqlParameter("@SafeCount", SqlDbType.VarChar, 50),
new SqlParameter("@Unit", SqlDbType.VarChar, 50),
new SqlParameter("@Versions", SqlDbType.VarChar, 50),
new SqlParameter("@Up_ID", SqlDbType.VarChar, 50),
new SqlParameter("@DrawingPatch", SqlDbType.VarChar, 255),
new SqlParameter("@Pic_ID", SqlDbType.VarChar, 50),
new SqlParameter("@Correlation_ID", SqlDbType.VarChar, 50),
new SqlParameter("@Remarks", SqlDbType.VarChar, 255),
new SqlParameter("@FAY_ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.Assembly_BarCode;
parameters[1].Value = model.Assembly_Name;
parameters[2].Value = model.BarCode;
parameters[3].Value = model.Name;
parameters[4].Value = model.Alias;
parameters[5].Value = model.Makedev;
parameters[6].Value = model.Model;
parameters[7].Value = model.FunctionRemarks;
parameters[8].Value = model.SafeCount;
parameters[9].Value = model.Unit;
parameters[10].Value = model.Versions;
parameters[11].Value = model.Up_ID;
parameters[12].Value = model.DrawingPatch;
parameters[13].Value = model.Pic_ID;
parameters[14].Value = model.Correlation_ID;
parameters[15].Value = model.Remarks;
parameters[16].Value = model.FAY_ID;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
