//更改 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); } }