/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.WorkStation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Workstation set ");
strSql.Append("Workstation=@Workstation");
strSql.Append(" where Wo_ID=@Wo_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Workstation", SqlDbType.VarChar, 15),
new SqlParameter("@Wo_ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.Workstation;
parameters[1].Value = model.Wo_ID;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//
//选择站别
//
private void cmb_Workstation_Receive_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cmb_Workstation_Receive.SelectedItem != null)
{
_WTT_WK = (Maticsoft.Model.WorkStation)cmb_Workstation_Receive.SelectedItem;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.WorkStation model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Workstation(");
strSql.Append("Workstation)");
strSql.Append(" values (");
strSql.Append("@Workstation)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Workstation", SqlDbType.VarChar, 15)
};
parameters[0].Value = model.Workstation;
object obj = dbs.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
//
//领料站别—改变站别
//
private void cmb_Workstation_Receive_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
_WTT_WK_Receive = (Maticsoft.Model.WorkStation)cmb_Workstation_Receive.SelectedItem;
cmb_State_Receive.ItemsSource = MCP_CS._M_StateList.GetModelList("Wk_ID='" + _WTT_WK_Receive.Wo_ID + "'");
if (cmb_State_Receive.Items.Count > 0)
{
cmb_State_Receive.SelectedIndex = 0;
}
}
catch (Exception) { throw; }
}
//
//选择投料记录
//
private void dgv_source_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
btn_Add.IsEnabled = false;
isEn(true, false);
_WTT_Material_Inject = (Maticsoft.Model.Material_Inject)dgv_source.SelectedItem;
txb_Count.Text = _WTT_Material_Inject.Count;
txb_JobNumber_Receive.Text = _WTT_Material_Inject.UserID;
_WTT_WK = MCP_CS._M_Workstation.GetModel(decimal.Parse(_WTT_Material_Inject.WK_ID));
cmb_Workstation_Receive.Text = _WTT_WK.Workstation;
}
catch { }
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.WorkStation DataRowToModel(DataRow row)
{
Maticsoft.Model.WorkStation model = new Maticsoft.Model.WorkStation();
if (row != null)
{
if (row["Wo_ID"] != null && row["Wo_ID"].ToString() != "")
{
model.Wo_ID = decimal.Parse(row["Wo_ID"].ToString());
}
if (row["Workstation"] != null)
{
model.Workstation = row["Workstation"].ToString();
}
}
return(model);
}
//
//用户列表
//
private void dgv_Source_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (dgv_Source.SelectedItem != null)
{
_WTT_User = (Maticsoft.Model.sysUser)dgv_Source.SelectedItem;
//
txb_Password.Text = _WTT_User.Password;
txb_JobNum.Text = _WTT_User.UserID;
txb_UserName.Text = _WTT_User.UserName;
cmb_Privilege.Text = _WTT_User.Privilege;
//
decimal _WK_ID = 0;
if (decimal.TryParse(_WTT_User.Workstation, out _WK_ID))
{
_WTT_Workstation = _M_Workstation.GetModel(_WK_ID);
cmb_Workstation.Text = _WTT_Workstation.Workstation;
}
}
}
//
//领料—工号
//
private void txb_JobNumber_Receive_KeyUp(object sender, KeyEventArgs e)
{
Maticsoft.BLL.sysUser _M_User = new Maticsoft.BLL.sysUser();
if (e.Key == Key.Enter && txb_JobNumber_Receive.IsFocused == true && txb_JobNumber_Receive.Text != "" &&
txb_JobNumber_Receive.Text != "002222")
{
_WTT_User_Receive = _M_User.GetModel(txb_JobNumber_Receive.Text.Trim());
if (_WTT_User_Receive != null)
{
int tem = -1; int.TryParse(_WTT_User_Receive.Workstation, out tem);
if (tem > -1)
{
cmb_Workstation_Receive.SelectedIndex = tem - 1;
_WTT_WK = (Maticsoft.Model.WorkStation)cmb_Workstation_Receive.SelectedItem;
}
txb_UserName_Receive.Text = _WTT_User_Receive.UserName;
}
else
{
txb_JobNumber_Receive.SelectAll();
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.WorkStation GetModel(string _workstation)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Wo_ID,Workstation from tb_Workstation ");
strSql.Append(" where Workstation=@Workstation");
SqlParameter[] parameters =
{
new SqlParameter("@Workstation", SqlDbType.VarChar)
};
parameters[0].Value = _workstation;
Maticsoft.Model.WorkStation model = new Maticsoft.Model.WorkStation();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
//
//选择站别
//
private void cmb_Workstation_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
_WTT_Workstation = (Maticsoft.Model.WorkStation)cmb_Workstation.SelectedItem;
}
