//更改
private void tsbUpdate_Click(object sender, EventArgs e)
{
string Msg = "是否要進行退貨單[" + txtRMAID.Text + "]更新動作?\r\n";
DialogResult DR;
DR = MessageBox.Show(Msg, "更新退貨單", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (DR == DialogResult.Yes)
{
if (CheckField(SIS.Configuration.CheckFieldType.Update))
{
SIS.DBClass.DBClassRMADetails DBCSD = new DBClass.DBClassRMADetails();
SIS.Configuration.Items[] oldItems = null;
oldItems = DBCSD.QueryData(txtRMAID.Text);
if (oldItems == null)
{
MessageBox.Show("對不起，資料庫不存在[ " + txtRMAID.Text +
" ]退貨單資料!!(資料不存在)", "資料更新");
return;
}
RunUpdateData(oldItems);
}
}
else
{
MessageBox.Show("取消退貨單更新動作!!", "更新退貨單");
}
}
/// <summary>
/// 查詢退貨單相關資料
/// </summary>
/// <param name="RMAID">傳入退貨單編號</param>
/// <param name="CRC">傳入存放查詢結果資料的SIS.Configuration.ClsRMAConfig CRC</param>
/// <returns></returns>
public bool QueryData(string RMAID, SIS.Configuration.ClsRMAConfig CRC)
{
InitDB();
string selectCmd;
selectCmd = "Select * From " + TableName + " Where RMAID='" + RMAID + "'";
try
{
cmd = new SqlCommand(selectCmd, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
CRC.RMAID = RMAID;
CRC.RMADate = dr["RMADate"].ToString();
CRC.RMAType = dr["RMAType"].ToString();
CRC.TotalPreTax = int.Parse(dr["TotalPreTax"].ToString());
CRC.Tax = int.Parse(dr["Tax"].ToString());
CRC.TotalAfterTax = int.Parse(dr["TotalAfterTax"].ToString());
CRC.StockIDOrShipID = dr["StockIDOrShipID"].ToString();
CRC.BusinessTax = int.Parse(dr["BusinessTax"].ToString());
CRC.AmountPaid = int.Parse(dr["AmountPaid"].ToString());
CRC.UnpaidAmount = int.Parse(dr["UnpaidAmount"].ToString());
CRC.RMAAmount = int.Parse(dr["RMAAmount"].ToString());
CRC.Staff = dr["Staff"].ToString();
CRC.PaymentType = dr["PaymentType"].ToString();
CRC.Notes = dr["Notes"].ToString();
conn.Close();
SIS.DBClass.DBClassRMADetails DBRD = new DBClassRMADetails();
CRC.RMAItems = DBRD.QueryData(RMAID);
if (CRC.RMAItems == null)
{
return(false);
}
else
{
return(true);
}
}
else
{
conn.Close();
return(false);
}
}
catch (Exception ex)
{
errorMsg = ex.Message;
conn.Close();
return(false);
}
}
