private void cboCustomer_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCustomer.Text != "")
{
string CustomerID = cboCustomer.Text.Split('-')[0];
My.MyDatabase myDB = new My.MyDatabase();
mtbPhone.Text = myDB.GetTableFieldData("CustomerInfo", "CustomerID", CustomerID, "Phone");
txtAddress.Text = myDB.GetTableFieldData("CustomerInfo", "CustomerID", CustomerID, "Address");
}
}
/// <summary>
/// 將角色編號轉換成角色名稱
/// </summary>
/// <param name="UserId">使用者帳號</param>
/// <returns></returns>
public string RoleIdToRoleName(string UserId)
{
InitDB();
string selectCmd;
string RoleId = "";
selectCmd = "Select * From " + TableName + " Where UserId='" + UserId + "'";
try
{
cmd = new SqlCommand(selectCmd, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
RoleId = dr["RoleId"].ToString();
conn.Close();
My.MyDatabase MyDB = new My.MyDatabase();
return(MyDB.GetTableFieldData("SysRole", "RoleId", RoleId, "RoleName"));
}
else
{
conn.Close();
return("error");
}
}
catch (Exception ex)
{
errorMsg = ex.Message;
conn.Close();
return(ex.Message.ToString());
}
}
private void cboPurchaseStaff_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboPurchaseStaff.Text != "")
{
string EmployeeID = cboPurchaseStaff.Text.Split('-')[0];
My.MyDatabase myDB = new My.MyDatabase();
mtbPurchasePhone.Text = myDB.GetTableFieldData("EmployeeInfo", "EmployeeID", EmployeeID, "Phone");
}
}