protected void gvDiaDiemThi_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string strReturn = string.Empty;
string strMess = string.Empty;
int iRow = gvDiaDiemThi.VisibleRowCount;
List<object> keyValues = gvDiaDiemThi.GetSelectedFieldValues("MaDiemThi");
foreach (object key in keyValues)
{
dthiDTO.MaDiemThi = key.ToString();
int iReturn = dthiDAL.Delete(dthiDTO);
if (iReturn < 0)
strMess += " " + key.ToString();
}
if (strMess != string.Empty)
e.Result = "Do ràng buộc dữ liệu, không thể xóa " + strMess;
else
e.Result = string.Empty;
gvDiaDiemThi.DataSource = loadDataToUI();
gvDiaDiemThi.Selection.SelectAll();
}
protected void gvCauHoiLoaiBang_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string strReturn = string.Empty;
string strMess = string.Empty;
int iRow = gvCauHoiLoaiBang.VisibleRowCount;
List<object> keyValues = gvCauHoiLoaiBang.GetSelectedFieldValues("STT");
foreach (object key in keyValues)
{
choilbangDTO.STT = key.ToString();
int iReturn = choilbangDAL.Delete(choilbangDTO);
if (iReturn < 0)
strMess += " " + key.ToString();
}
if (strMess != string.Empty)
e.Result = "Do ràng buộc dữ liệu, không thể xóa " + strMess;
else
e.Result = string.Empty;
gvCauHoiLoaiBang.DataSource = loadDataToUI();
gvCauHoiLoaiBang.Selection.SelectAll();
}
protected void gvThiSinh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
thisinhDTO = new clsThiSinh_DTO();
string strReturn = string.Empty;
string strMess = string.Empty;
int iRow = gvThiSinh.VisibleRowCount;
List<object> keyValues = gvThiSinh.GetSelectedFieldValues("MaTS");
foreach (object key in keyValues)
{
thisinhDTO.MaTS = key.ToString();
int iReturn = thisinhDAL.Delete(thisinhDTO);
if (iReturn < 0)
strMess += " " + key.ToString();
}
if (strMess != string.Empty)
e.Result = "Do ràng buộc dữ liệu, không thể xóa " + strMess;
else
e.Result = string.Empty;
gvThiSinh.DataSource = loadDataToUI(thisinhDTO);
gvThiSinh.Selection.SelectAll();
}
protected void gvNguoiDung_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
ndungDTO = new clsNguoiDung_DTO();
string strReturn = string.Empty;
string strMess = string.Empty;
int iRow = gvNguoiDung.VisibleRowCount;
List<object> keyValues = gvNguoiDung.GetSelectedFieldValues("TenDangNhap");
foreach (object key in keyValues)
{
ndungDTO.TenDangNhap = key.ToString();
int iReturn = ndungDAL.Delete(ndungDTO);
if (iReturn < 0)
strMess += " " + key.ToString();
}
if (strMess != string.Empty)
e.Result = "Do ràng buộc dữ liệu, không thể xóa " + strMess;
else
e.Result = string.Empty;
gvNguoiDung.DataSource = loadDataToUI();
gvNguoiDung.Selection.SelectAll();
}
protected void grid_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string par = e.Parameters;
string[] ar = par.Split('_');
if (par == "OK")
{
#region Create Inv
if (Request.QueryString["no"] != null)
{
try
{
bool action = true;
string res = "";
string no = SafeValue.SafeString(Request.QueryString["no"]);
string type = SafeValue.SafeString(Request.QueryString["type"]);
if (action)
{
#region Create Inv
string docId = "";
if (list.Count > 0)
{
string jobNo = SafeValue.SafeString(Request.QueryString["no"]);
string client = SafeValue.SafeString(Request.QueryString["client"]);
string contType = SafeValue.SafeString(Request.QueryString["contType"]);
string user = HttpContext.Current.User.Identity.Name;
string acCode = EzshipHelper.GetAccArCode("", "SGD");
DateTime dtime = txt_DocDt.Date;
string invN = C2Setup.GetNextNo("", "AR-IV", dtime);
string termId = EzshipHelper.GetTerm(client);
string term = EzshipHelper.GetTermCode(termId);
string currency = cmb_CurrencyId.Text;
decimal exrate = SafeValue.SafeDecimal(spin_ExRate.Value);
string sql_att = string.Format(@"select ClientContact from ctm_job where JobNo='{0}'", jobNo);
string contact = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql_att));
string sql = string.Format(@"insert into XAArInvoice (DocType,DocDate,PartyTo,DocNo,AcYear,AcPeriod,Term,DocDueDate,Description,
CurrencyId,MastType,ExRate,ExportInd,CancelDate,CancelInd,UserId,EntryDate,Eta,AcCode,AcSource,MastRefNo,Contact)
values('IV','{5:yyyy-MM-dd}','{4}','{0}','{6}','{7}','{8}','{5:yyyy-MM-dd}','',
'{9}','STORAGE',{10},'N','19000101','N','{1}',getdate(),'17530101','{2}','DB','{3}','{11}')
select @@IDENTITY", invN, user, acCode, jobNo, client, dtime, dtime.Year, dtime.Month, term, currency, exrate, contact);
docId = ConnectSql_mb.ExecuteScalar(sql);
C2Setup.SetNextNo("", "AR-IV", invN, dtime);
string code = "";
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
string chgCode = list[i].chgCode;
string chgcodeDes = list[i].chgCodedes;
if (IsCostCreated(id))
{
C2.ComMethod.CreateInv(invN, id, docId, i, "", currency, exrate);
}
else
{
if (list.Count - i > 1)
{
code += chgcodeDes + " / ";
}
else
{
code += chgcodeDes;
}
}
}
C2.XAArInvoice.update_invoice_mast(SafeValue.SafeInt(docId, 0));
if (code.Length == 0)
{
e.Result = invN;
}
else
{
e.Result = "Action Error!" + code + " already exist !";
}
}
else
{
e.Result = "Action Error!Please keyin select cost ";
}
#endregion
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isINVOICE(SafeValue.SafeInt(docId, 0));
elog.setActionLevel(SafeValue.SafeInt(docId, 0), CtmJobEventLogRemark.Level.Invoice, 3);
elog.log();
}
else
{
e.Result = res;
}
}
catch { }
}
#endregion
}
if (par == "Save")
{
#region Save All
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
string contNo = list[i].contNo;
string contType = list[i].contType;
decimal price = list[i].price;
decimal qty = list[i].qty;
string unit = list[i].unit;
string code = list[i].chgCode;
string des = list[i].chgCodedes;
int lineIndex = list[i].lineIndex;
string remark = list[i].remark;
string groupBy = list[i].groupBy;
decimal locAmt = SafeValue.ChinaRound(qty * SafeValue.SafeDecimal(price, 0), 2);
string sql = string.Format(@"update job_cost set ContNo='{0}',ContType='{1}',Price={2},Qty={3},LocAmt={4},Unit='{6}',ChgCode='{7}',ChgCodeDes='{8}',LineIndex={9},Remark='{10}',GroupBy='{11}' where Id={5}",
contNo, contType, price, qty, locAmt, id, unit, code, des, lineIndex, remark, groupBy);
ConnectSql.ExecuteSql(sql);
}
e.Result = "Save Success";
}
else
{
e.Result = "Action Error!Please keyin select cost ";
}
#endregion
}
if (ar.Length >= 2)
{
if (ar[0].Equals("SaveInvline"))
{
int rowIndex = SafeValue.SafeInt(ar[1], -1);
e.Result = Save_Inline(rowIndex, e);
}
}
}
