protected void Page_Load(object sender, EventArgs e)
{
string inputValue = "<InputValue UserID=\"2\" /><RequestParams draw=\"1\" start=\"0\" length=\"1\" Sys_ViewID=\"20\" />";
DataSet data = new CCoreService().GetContextDataSet("", inputValue);
ExcelPlusExport(data.Tables[0], Context);
}
public List <CProjectTracking> GetProjectTraking(string ClientKey, string InputValue)
{
string data = new CCoreService().GetContextData(ClientKey, InputValue);
List <CProjectTracking> list = CDataParser.FromCSV <CProjectTracking>(data, 1);
return(list);
//return "Hello World";
}
private void GetInfoByOriginalRefNo_1(string OrgRefNo)
{
if (string.IsNullOrEmpty(OrgRefNo))
{
return;
}
CCoreService service = new CCoreService();
string inputValue = string.Format("<InputValue UserID=\"{1}\" /><RequestParams Function='GetTransaction_Asset' RefType='22' RegisTransRefNo='{0}'/>", OrgRefNo, CSession.UserID);
inputValue = inputValue + string.Format("<RequestParams Function=\"GetTransaction_Asset\" RefType=\"21\" RefNo=\"{0}\" Context=\"AssetsList\"/>", OrgRefNo);
inputValue = inputValue + string.Format("<RequestParams Function=\"GetTransaction_Asset\" RefType=\"21\" RefNo=\"{0}\" Context=\"AssetOwnerList\"/>", OrgRefNo);
string datacsv = service.GetContextData(CSession.CLIENT_KEY, CXML.HtmlEnCode(inputValue));
IList <CTransaction> trans = CObjectMapper.FromCSV <CTransaction>(datacsv, 1);
List <Asset> asset = CObjectMapper.FromCSV <Asset>(datacsv, 2);
List <Person> ownner = CObjectMapper.FromCSV <Person>(datacsv, 3);
if (trans != null && trans.Count > 0)
{
if (CurrentTransaction.Assets == null || CurrentTransaction.Assets.Count == 0)
{
CurrentTransaction.Assets = asset;
}
if (CurrentTransaction.AssetOwnerID == 0 && !string.IsNullOrEmpty(CurrentTransaction.AssetOwnerName))
{
CurrentTransaction.AssetOwnerID = trans[0].AssetOwnerID;
}
if (string.IsNullOrEmpty(CurrentTransaction.AssetOwnerName))
{
CurrentTransaction.AssetOwnerName = trans[0].AssetOwnerName;
}
if (string.IsNullOrEmpty(CurrentTransaction.AssetPersonalCode))
{
CurrentTransaction.AssetPersonalCode = trans[0].AssetPersonalCode;
}
if (CurrentTransaction.AssetOwnnerList == null || CurrentTransaction.AssetOwnnerList.Count == 0)
{
CurrentTransaction.AssetOwnnerList = ownner;
}
BindingSource source = new BindingSource();
source.DataSource = CurrentTransaction.AssetOwnnerList;
grAssetOwnner.DataSource = source;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
//Kiem tra so don co dung la don dang ky ban dau hay don thay doi cua don dk ban dau ko
try
{
if (string.IsNullOrEmpty(txtOldRefNo.Text.Trim()))
{
ShowError("Số đơn nhập vào không hợp lệ.");
return;
}
CCoreService service = new CCoreService();
string inputValue = string.Format("<RequestParams Function=\"GetTransaction_Asset\" RefType=\"21\" RefNo=\"{0}\" Context=\"{1}\" />", txtOldRefNo.Text, "CHECKSCSS");
string datacsv = service.GetContextData(CSession.CLIENT_KEY, inputValue);
IList <CTransaction> trans = CObjectMapper.FromCSV <CTransaction>(datacsv, 1);
if (trans != null && trans.Count > 0)
{
if (!trans[0].RefNo.Trim().Equals(CurrentTransaction.OrgRefNo.Trim(), StringComparison.OrdinalIgnoreCase) &&
(string.IsNullOrEmpty(trans[0].OrgRefNo) || !trans[0].OrgRefNo.Trim().Equals(CurrentTransaction.OrgRefNo.Trim(), StringComparison.OrdinalIgnoreCase)))
{
ShowError("Số đơn nhập vào không hợp lệ.");
//this.DialogResult = System.Windows.Forms.DialogResult.Cancel;
return;
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
return;
}
else
{
if (MessageBox.Show("Số đơn nhập vào không tồn tại trong hệ thống. Hệ thống sẽ tự động tạo đơn và tính phí theo số đơn này?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
return;
}
return;
}
}
catch (Exception ex)
{
ShowError(ex.Message);
this.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.Close();
return;
}
}
public bool UpdateTransaction()
{
UpdateSoDonNhan();
CurrentTransaction.ReceiveDateTime = GetReceiveDateTime();// txtReceiveDateTime.Value;
CurrentTransaction.NumPagesAttachment = (int)txtNumPagesAttachment.Value;
//CurrentTransaction.AssetIDCardNo = txtIDNo.Text;
CurrentTransaction.AssetPersonalCode = txtPersonalCode.Text;
string requestparams = CurrentTransaction.GetRequestParams("Function='Transaction_Asset' Action='UPDATEGCN'");
CCoreService service = new CCoreService();
requestparams = CXML.AddAuthenticate(requestparams);
string messageCSV = service.ExecuteAction(CSession.CLIENT_KEY, CXML.HtmlEnCode(requestparams));
IList <FWS.TTDKGDTS.ImportTool.BusinessObject.CApplicationMessage> message = CObjectMapper.FromCSV <FWS.TTDKGDTS.ImportTool.BusinessObject.CApplicationMessage>(messageCSV, 1);
if (message[0].Result == null || message[0].Result.ToString() == "" || message[0].Result.ToString() == "0")
{
MessageBox.Show(message[0].Description);
return(false);
}
return(true);
}
private void InitComboboxData()
{
CCoreService service = new CCoreService();
string inputValue = "<InputValue UserID=\"14\" />";
inputValue += "<RequestParams Function='GetPerson' FilterCode='BANK'/>";
//inputValue += "<RequestParams Function='FilterParaData' ListFunction='VoucherActionType'/>";
string datacsv = service.GetContextData(CSession.CLIENT_KEY, CXML.HtmlEnCode(inputValue));
//directionDataSource = CObjectMapper.FromCSV<CParaData>(datacsv, 2);
//txtDirection.DisplayMember = "Name";
//txtDirection.ValueMember = "ID";
//txtDirection.DataSource = directionDataSource;
//IList<CParaData> actionlist = CObjectMapper.FromCSV<CParaData>(datacsv, 3);
//txtVoucherActionType.DisplayMember = "Name";
// txtVoucherActionType.ValueMember = "Value";
//txtVoucherActionType.DataSource = actionlist;
directionDataSource = CObjectMapper.FromCSV <CPerson>(datacsv, 1);
//txtDirection.DisplayMember = "Name";
//txtDirection.ValueMember = "ID";
//txtDirection.DataSource = directionDataSource;
txtKHTX.Items.Clear();
foreach (CPerson d in directionDataSource)
{
txtKHTX.Items.Add(new Core.AutoComplete.AutoCompleteEntry(d.Name, d.Code, d.Name, d.Address)
{
Value = d.ID, DisplayMemberSub = d.Code + " - " + d.Address, Tag = d
});
}
}
public bool UpdateTransaction()
{
// == Kiem tra RefNo truoc neu refno moi
if (isNew)
{
string inputValue = string.Format("<InputValue RefType='28' RefDate='{0}'/>", DateTime.Now.ToString("yyyy-MM-dd"));
CRefNo objRefNo = CServiceReference.CoreService.GetNextRefNo(inputValue);
int compareResult = string.Compare(objRefNo.RefNo, txtRefNo.Text, true);
if (compareResult > 0)
{
DialogResult dr = ShowQuestion("Số công văn đã thay đổi, số mới là:" + objRefNo.RefNo + ". Bạn có muốn in với số mới không?");
if (dr == DialogResult.Yes)
{
txtRefNo.Text = objRefNo.RefNo;
}
else
{
return(false);
}
}
}
// CurrentTransaction.OldRefNo = txtOldRefNo.Text;
//CurrentTransaction.AssetType = int.Parse(txtAssetType.SelectedValue.ToString());
CurrentTransaction.RefDate = GetRefDateTime();
//CurrentTransaction.RefNo = txtRefNo.Text;// CurrentTransaction.RegisTransRefNo;
//CurrentTransaction.RefType = 21;
//CurrentTransaction.Type = int.Parse(txtVoucherActionType.SelectedValue.ToString());
//CurrentTransaction.ObjectID = int.Parse(txtDirection.SelectedValue.ToString());
CurrentTransaction.Note = txtReason.Text;
CurrentTransaction.SendGCNEmail = txtEmail.Text;
if (txtKHTX.SelectedItem != null)
{
CurrentTransaction.WarranterID = (int)txtKHTX.SelectedItem.Value;
CurrentTransaction.WarranterName = txtKHTX.Text;
CurrentTransaction.WarranterAddress = txtAddress.Text;
//CurrentTransaction.ObjectEmail = txtObjectEmail.Text;
}
else
{
CurrentTransaction.WarranterID = 0;
CurrentTransaction.WarranterName = txtKHTX.Text;
CurrentTransaction.WarranterAddress = txtAddress.Text;
//CurrentTransaction.ObjectEmail = txtObjectEmail.Text;
}
//CurrentTransaction.IsSendMail = chkSendMail.Checked;
//CurrentTransaction.IsSendMailKH = chkSendEmailKH.Checked;
//CurrentTransaction.WarranterEmail = txtWarranterEmail.Text;
string requestparams = CurrentTransaction.GetRequestParams("Function='Transaction_Asset' Action='UPDATE' Context='TOOL'");
CCoreService service = new CCoreService();
requestparams = CXML.AddAuthenticate(requestparams);
string messageCSV = service.ExecuteAction(CSession.CLIENT_KEY, CXML.HtmlEnCode(requestparams));
IList <FWS.TTDKGDTS.ImportTool.BusinessObject.CApplicationMessage> message = CObjectMapper.FromCSV <FWS.TTDKGDTS.ImportTool.BusinessObject.CApplicationMessage>(messageCSV, 1);
if (message[0].Result == null || message[0].Result.ToString().Equals("") || message[0].Result.ToString().Equals("0"))
{
Message = message[0].Description;
//MessageBox.Show(message[0].Description);
return(false);
}
return(true);
}
public void InitControl(string RegisTransRefNo)
{
//Lay du lieu tu so don dang ky
InitComboboxData();
//InitGridColumn();
CCoreService service = new CCoreService();
string inputValue = string.Format("<RequestParams Function='GetTransaction_Asset' RefType='28' RegisTransRefNo='{0}' Context=\"{1}\" />", RegisTransRefNo, "TOOL_PRINT");
//inputValue = string.Format("<RequestParams Function='GetTransaction_Asset' RefType='21' RefNo='{0}' />", RegisTransRefNo);
//inputValue = inputValue + string.Format("<RequestParams Function='GetTransaction_Asset' RefType='21' RefNo='{0}' Context='AssetsList'/>", RegisTransRefNo);
inputValue = inputValue + string.Format("<RequestParams Function='GetTransaction_Asset' RefType='21' RefNo='{0}' Context='WarranterList'/>", RegisTransRefNo);
//inputValue = inputValue + string.Format("<RequestParams Function='GetTransaction_Asset' RefType='21' RefNo='{0}' Context='AssetOwnerList'/>", RegisTransRefNo);
inputValue = inputValue + "<RequestParams Function='FilterParaData' ListFunction='VoucherActionType'/>";
string datacsv = service.GetContextData(CSession.CLIENT_KEY, inputValue);
IList <CTransaction> trans = CObjectMapper.FromCSV <CTransaction>(datacsv, 1);
List <Person> waranter = CObjectMapper.FromCSV <Person>(datacsv, 2);
if (waranter == null)
{
waranter = new List <Person>();
}
IList <CParaData> actionlist = CObjectMapper.FromCSV <CParaData>(datacsv, 3);
gridAcctionType = new List <CParaData>();
gridAcctionType.Add(new CParaData()
{
Name = "...", ID = 0, Value = "0"
});
foreach (CParaData para in actionlist)
{
if (para.ID == 93 || para.ID == 95)
{
gridAcctionType.Add(para);
}
}
if (trans != null && trans.Count > 0)
{
//InitAssetOwnnerGridColumn();
//InitWarranterGridColumn();
//Neu RefNo = Empty thi lay RefNo moi tu va enable textbox cho phep edit RefNo
//Khoa lai chuc nang Edit RefNo
if (string.IsNullOrEmpty(trans[0].RefNo))
{
inputValue = string.Format("<InputValue RefType='28' RefDate='{0}'/>", DateTime.Now.ToString("yyyy-MM-dd"));
CRefNo objRefNo = service.GetNextRefNo(inputValue);
trans[0].RefNo = objRefNo.RefNo;
txtRefNo.Enabled = false;
pnDate.Enabled = false;
isNew = true;
}
else
{
txtRefNo.Enabled = false;
pnDate.Enabled = false;
isNew = false;
}
txtRefNo.Text = trans[0].RefNo;
SetRefDateTime(trans[0].RefDate);
//txtRefDate.Value = trans[0].RefDate;
txtRegisTransRefNo.Text = trans[0].RegisTransRefNo;
//txtOldRefNo.Text = trans[0].OldRefNo;
//txtAssetType.SelectedValue = trans[0].AssetType.ToString();
//txtDirection.SelectedValue = trans[0].ObjectID.ToString();
if (trans[0].WarranterID > 0)
{
txtKHTX.SelectedValue = trans[0].WarranterID;
txtAddress.Text = trans[0].WarranterAddress;
}
else if (trans[0].ID > 0)
{
txtKHTX.Text = trans[0].WarranterName;
txtAddress.Text = trans[0].WarranterAddress;
}
else
{
if (waranter != null && waranter.Count > 0)
{
txtKHTX.Text = waranter[0].ObjectName;
txtAddress.Text = waranter[0].ObjectAddress;
}
}
txtReason.Text = trans[0].Note;
//txtVoucherActionType.SelectedValue = trans[0].Type.ToString();
//txtObjectEmail.Text = trans[0].ObjectEmail;
//txtWarranterEmail.Text = trans[0].WarranterEmail;
//lbAttachName.Text = trans[0].FileNumber;
CurrentTransaction = trans[0];
//trans[0].Assets = assets;
//SetAssetToGrid();
//SetDefaultAssetName(grAsset);
//SetDefaultAssetName(grAssetOther);
//BindingSource Ownnersource = new BindingSource();
//Ownnersource.DataSource = CurrentTransaction.AssetOwnnerList;
//grAssetOwner.DataSource = Ownnersource;
//BindingSource warrantersource = new BindingSource();
//warrantersource.DataSource = CurrentTransaction.WarranterList;
//grWarranter.DataSource = warrantersource;
}
//raise su kien de sua du lieu cot loai dang ky
//txtVoucherActionType_SelectedIndexChanged(null, null);
//Mac dinh check all
if (ckSelectAssetHeader != null)
{
ckSelectAssetHeader.Checked = true;
//ckSelectAssetHeader_CheckedChanged(null, null);
}
}
private void GetInfoByOriginalRefNo(string OrgRefNo)
{
if (string.IsNullOrEmpty(OrgRefNo))
{
return;
}
CCoreService service = new CCoreService();
string inputValue = string.Format("<InputValue UserID=\"{1}\" /><RequestParams Function='GetTransaction_Asset' RefType='22' RegisTransRefNo='{0}'/>", OrgRefNo, CSession.UserID);
inputValue = inputValue + string.Format("<RequestParams Function=\"GetTransaction_Asset\" RefType=\"21\" RefNo=\"{0}\" Context=\"AssetOwnerList\"/>", OrgRefNo);
inputValue = inputValue + string.Format("<RequestParams Function=\"GetTransaction_Asset\" RefType=\"21\" RefNo=\"{0}\" Context=\"AssetOwnerList\"/>", CurrentTransaction.RefNo);
inputValue = inputValue + string.Format("<RequestParams Function=\"GetTransaction_Asset\" RefType=\"21\" RefNo=\"{0}\" Context=\"WarranterList\"/>", OrgRefNo);
inputValue = inputValue + string.Format("<RequestParams Function=\"GetTransaction_Asset\" RefType=\"21\" RefNo=\"{0}\" Context=\"WarranterList\"/>", CurrentTransaction.RefNo);
string datacsv = service.GetContextData(CSession.CLIENT_KEY, CXML.HtmlEnCode(inputValue));
IList <CTransaction> trans = CObjectMapper.FromCSV <CTransaction>(datacsv, 1);
List <Person> OrgAssetOwner = CObjectMapper.FromCSV <Person>(datacsv, 2);
if (OrgAssetOwner == null)
{
OrgAssetOwner = new List <Person>();
}
List <Person> AssetOwner = CObjectMapper.FromCSV <Person>(datacsv, 3);
if (AssetOwner == null)
{
AssetOwner = new List <Person>();
}
List <Person> OrgWarraner = CObjectMapper.FromCSV <Person>(datacsv, 4);
if (OrgWarraner == null)
{
OrgWarraner = new List <Person>();
}
List <Person> Warraner = CObjectMapper.FromCSV <Person>(datacsv, 5);
if (Warraner == null)
{
Warraner = new List <Person>();
}
if (trans != null && trans.Count > 0)
{
if (string.IsNullOrEmpty(txtPersonalCode.Text))
{
txtPersonalCode.Text = trans[0].AssetPersonalCode;
}
//txtAssetType.SelectedValue = trans[0].AssetType.ToString();
//txtDirection.SelectedValue = trans[0].ObjectID;
//txtCQCN.SelectedValue = trans[0].ObjectID;
if (Warraner == null || Warraner.Count == 0)
{
CurrentTransaction.WarranterList = OrgWarraner;
BindingSource source = new BindingSource();
source.DataSource = CurrentTransaction.WarranterList;
grWarranter.DataSource = source;
}
if (AssetOwner == null || AssetOwner.Count == 0)
{
CurrentTransaction.AssetOwnnerList = OrgAssetOwner;
BindingSource source = new BindingSource();
source.DataSource = CurrentTransaction.AssetOwnnerList;
grAssetOwnner.DataSource = source;
}
//CurrentTransaction.AssetOwnnerList = asset;
}
}
