public bool Update(SystemHelp model, List <string> fileds, string sqlWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("update {0} set ", model.GetType().Name);
List <string> filedsList = new List <string>();
List <SqlParameter> sqlParameter = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@Id", SqlDbType.Int, 4);
if (string.IsNullOrEmpty(sqlWhere))
{
Param.Value = model.Id;
sqlParameter.Add(Param);
}
foreach (string filed in fileds)
{
filedsList.Add(string.Format("{0}=@{0}", filed));
Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null));
sqlParameter.Add(Param);
}
strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray()));
if (string.IsNullOrEmpty(sqlWhere))
{
strSql.Append(" where Id=@Id ");
}
else
{
strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere);
}
SqlParameter[] parameters = sqlParameter.ToArray();
return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false);
}
} // delegate in FrmLogin
#endregion
#region "event"
private void FrmMain_Load(object sender, EventArgs e)
{
try
{
this.Hide();
FrmLogin frmLogin = new FrmLogin();
frmLogin._getUserName = new FrmLogin.GetUserName(GetUserNameLogin);
if (frmLogin.ShowDialog(this) == DialogResult.OK)
{
Center_employee center_Employee = new Center_employee();
_employee = center_Employee.GetByUserName(_userName);
this.Show();
toolStripStatusLabel1.Text = string.Format(SystemMessage.StatusInfo, _employee.displayname);
}
else
{
SystemHelp.ClosedAllChild(this);
Application.Exit();
}
}
catch (Exception ex)
{
Console.Write(ex + "");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SystemHelp model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemHelp(");
strSql.Append("AskContent,ReplyConent,AskAccount,ReplyAccount,AskDate,ReplyDate,HelpType");
strSql.Append(") values (");
strSql.Append("@AskContent,@ReplyConent,@AskAccount,@ReplyAccount,@AskDate,@ReplyDate,@HelpType");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AskContent", SqlDbType.VarChar, 1000),
new SqlParameter("@ReplyConent", SqlDbType.VarChar, 4000),
new SqlParameter("@AskAccount", SqlDbType.VarChar, 50),
new SqlParameter("@ReplyAccount", SqlDbType.VarChar, 50),
new SqlParameter("@AskDate", SqlDbType.DateTime),
new SqlParameter("@ReplyDate", SqlDbType.DateTime),
new SqlParameter("@HelpType", SqlDbType.Int, 4)
};
parameters[0].Value = model.AskContent;
parameters[1].Value = model.ReplyConent;
parameters[2].Value = model.AskAccount;
parameters[3].Value = model.ReplyAccount;
parameters[4].Value = model.AskDate;
parameters[5].Value = model.ReplyDate;
parameters[6].Value = model.HelpType; return(sqlhelper.ExecNon(strSql.ToString(), parameters));
}
public JsonResult addEditSysHelp(SystemHelp systemHelp)
{
JsonResult result = null;
try
{
BaseResultDto <string> resultDto = new BaseResultDto <string>();
//添加或者修改
if (systemHelp.Id > 0)
{
//修改
resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}SysSetting/UpdateHelp", this.WebApiUrl), systemHelp);
}
else
{
systemHelp.ReplyAccount = this.UserInfo.UserName;
//systemHelp.ReplyDate = this.UserInfo.UserName;
//添加
resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}SysSetting/AddHelp", this.WebApiUrl), systemHelp);
}
result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet);
}
return(result);
}
private void btnLogin_Click(object sender, EventArgs e)
{
string uName = txtUserName.Text.Trim();
string pWord = txtPassWord.Text.Trim();
#region "CheckInput"
if (uName == "")
{
txtUserName.Focus();
lblMsg.Text = SystemMessage.WarningUsername;
return;
}
if (pWord == "")
{
txtPassWord.Focus();
lblMsg.Text = SystemMessage.WarningPassword;
return;
}
#endregion
#region "Login"
try
{
pWord = SystemHelp.Encrypt(pWord);
var dao = new Center_employee();
int rs = dao.UserIsLogin(uName, pWord);
if (rs == 0)
{
lblMsg.Text = SystemMessage.WarningErrorUsername;
return;
}
else if (rs == 1)
{
lblMsg.Text = SystemMessage.WarningAccess;
return;
}
else if (rs == 2)
{
lblMsg.Text = SystemMessage.WarningStatus;
return;
}
else
{
_getUserName(uName);
DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
Console.Write(ex.ToString());
lblMsg.Text = SystemMessage.WarningConnection;
}
#endregion
}
private void item_InputTicket_Click(object sender, EventArgs e)
{
if (!SystemHelp.CheckExitForm("Frm_InputTicket", this))
{
Frm_InputTicket frm = new Frm_InputTicket();
SystemHelp.ShowChildForm(frm, this);
}
else
{
SystemHelp.ActiveChildForm("Frm_InputTicket", this);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
string oldPass = txtPassOld.Text.Trim();
string newPass = txtPassNew.Text.Trim();
string confirmPass = txtPassConfirm.Text.Trim();
#region "checkInput"
if (oldPass == "")
{
lblMsg.Text = SystemMessage.WarningPassword;
txtPassOld.Focus();
return;
}
if (newPass == "")
{
lblMsg.Text = SystemMessage.WarningPassword;
txtPassNew.Focus();
return;
}
if (newPass != confirmPass)
{
lblMsg.Text = SystemMessage.WarningConfirmPassword;
txtPassConfirm.Focus();
return;
}
oldPass = SystemHelp.Encrypt(oldPass);
if (oldPass != _employee.password)
{
lblMsg.Text = SystemMessage.WarningOldPassword;
return;
}
#endregion
#region "update"
_employee.password = oldPass;
var employee_ = new Center_employee();
if (employee_.Update(_employee))
{
lblMsg.Text = SystemMessage.LogUpdateSuccess;
txtPassOld.Text = "";
txtPassNew.Text = "";
txtPassConfirm.Text = "";
}
else
{
lblMsg.Text = SystemMessage.ErrorChangerPassword;
}
#endregion
}
private void item_DeliveryTicket_Click(object sender, EventArgs e)
{
if (!SystemHelp.CheckExitForm("Frm_DeliveryTicket", this))
{
Frm_DeliveryTicket frm = new Frm_DeliveryTicket();
frm.ObjLogin = _employee;
SystemHelp.ShowChildForm(frm, this);
}
else
{
SystemHelp.ActiveChildForm("Frm_DeliveryTicket", this);
}
}
private void item_ChangerPass_Click(object sender, EventArgs e)
{
// Nho khong de Name va text form giong nhau
if (!SystemHelp.CheckExitForm("FrmChangerPass", this))
{
FrmChangerPass frm = new FrmChangerPass();
frm._employee = _employee;
SystemHelp.ShowChildForm(frm, this);
}
else
{
SystemHelp.ActiveChildForm("FrmChangerPass", this);
}
}
public BaseResultDto <string> AddHelp(SystemHelp model)
{
BaseResultDto <string> resultDto = new BaseResultDto <string>();
try
{
resultDto.ErrorCode = helper.Add <SystemHelp>(model);
resultDto.ErrorMsg = "添加成功";
}
catch (Exception ex)
{
resultDto.ErrorCode = -1;
resultDto.ErrorMsg = ex.Message;
}
return(resultDto);
}
private void FrmMain_FormClosing(object sender, FormClosingEventArgs e)
{
var rs = MessageBox.Show(SystemMessage.WarningExitAppication,
SystemMessage.CaptionConfirmMessage, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (rs == DialogResult.Yes)
{
SystemHelp.ClosedAllChild(this);
Dispose(true);
Application.Exit();
}
else
{
e.Cancel = true;
}
}
public BaseResultDto <string> UpdateHelp(SystemHelp model)
{
BaseResultDto <string> resultDto = new BaseResultDto <string>();
try
{
resultDto.ErrorCode = helper.Update <SystemHelp>(model) ? 1 : 0;
resultDto.ErrorMsg = "修改成功";
}
catch (Exception ex)
{
resultDto.ErrorCode = -1;
resultDto.ErrorMsg = ex.Message;
}
return(resultDto);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="help"></param>
/// <returns></returns>
public JsonResult DelHelp(SystemHelp help)
{
JsonResult result = null;
try
{
//删除帮助
BaseResultDto <string> resultDto = HttpHelper.CreatHelper().DoGetObject <BaseResultDto <string> >(string.Format("{0}SysSetting/DeleteHelp?Id={1}", this.WebApiUrl, help.Id));
result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet);
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SystemHelp GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, AskContent, ReplyConent, AskAccount, ReplyAccount, AskDate, ReplyDate, HelpType ");
strSql.Append(" from SystemHelp ");
strSql.Append(" where ");
strSql.Append(where);
var dt = sqlhelper.GetTable(strSql.ToString());
SystemHelp model = null;
if (dt.Rows.Count > 0)
{
model = Mapper.DynamicMap <IDataReader, List <SystemHelp> >(dt.CreateDataReader()).FirstOrDefault();
}
return(model);
}
private void txtSerieEnd_KeyUp(object sender, KeyEventArgs e)
{
if (_flag == -1)
{
return;
}
try
{
#region "input"
lblMsg.Text = "";
string _serieStart = txtSerieStart.Text.Trim().ToUpper();
string _serieEnd = txtSerieEnd.Text.Trim().ToUpper();
if (_serieStart == "" || _serieEnd == "")
{
return;
}
string _ticketSerie = _serieStart.Substring(0, 10);
string _ticketType = _serieStart.Substring(8, 1);
int _sNum = Int32.Parse(_serieStart.Substring(10));
int _eNum = Int32.Parse(_serieEnd.Substring(10));
#endregion
#region "check_inputSerie"
int rs = SystemHelp.CheckInputSerie(_serieStart, _serieEnd, _ticketSerie, _ticketType, _sNum, _eNum);
if (rs == 1)
{
lblMsg.Text = SystemMessage.WarningStartNumberErr;
return;
}
else if (rs == 2)
{
lblMsg.Text = SystemMessage.WarningTicketTypeErr;
return;
}
else if (rs == 3)
{
lblMsg.Text = SystemMessage.WarningMinMaxErr;
return;
}
else if (rs == 4)
{
lblMsg.Text = SystemMessage.WarningTicketTypeErr;
return;
}
#endregion
#region "check_select_employee"
if (cboEmployee.SelectedIndex == 0 && _flag == 1)
{
lblMsg.Text = SystemMessage.WarningEmployeeNull;
txtSerieEnd.Text = "";
txtSerieStart.Text = "";
cboEmployee.Focus();
return;
}
#endregion
if (_flag == 0)
{
_flag = 2;
}
// get ticket_type
var itemTicketType = SystemHelp.GetTicketTypeFromList(_ticketSerie, _lstTicketType);
// create obj ticket_delivery
center_ticket_delivery itemTicket_delivery = new center_ticket_delivery()
{
delivery_date = DateTime.Now,
deliveryer_name = ObjLogin.displayname,
deliveryer = ObjLogin.id,
receiver_name = cboEmployee.Text,
receiver = Int32.Parse(cboEmployee.SelectedValue.ToString()),
ticket_name = itemTicketType.ticket_name,
ticket_type = itemTicketType.id,
quantity = _eNum - _sNum + 1,
startSerie = _sNum,
endSerie = _eNum,
ticketSerie = _ticketSerie,
session_id = 0
};
// nhap cua them moi
if (_flag == 1)
{
// check ticket_delivery in grid
if (CheckTicketInGrid(itemTicket_delivery))
{
lblMsg.Text = SystemMessage.WarningExitInputTicket;
return;
}
// check ticket_delivery in table
if (FindInListTable(itemTicket_delivery, _lstTicketDelivery) != null)
{
lblMsg.Text = SystemMessage.WarningSaveTicketDelivery;
return;
}
// add ticket to grid
AddRowToGrid(itemTicket_delivery);
cboEmployee.Enabled = false;
txtSerieStart.Text = "";
txtSerieEnd.Text = "";
txtSerieStart.Focus();
}
else if (_flag == 2)
{
// nhap cua tim serie ve
_flag = 0;
if (_pageTotal > 0)
{
dtGrid.Rows.Clear();
var item = FindInListTable(itemTicket_delivery, _lstTicketDelivery);
if (item == null)
{
lblMsg.Text = "Không tim thấy vé.";
cboEmployee.SelectedIndex = 0;
lblPageInfo.Text = "";
return;
}
DataGridViewRow row = (DataGridViewRow)dtGrid.RowTemplate.Clone();
row.CreateCells(dtGrid,
1,
false,
item.ticket_name,
item.ticketSerie,
item.startSerie,
item.endSerie,
item.quantity,
item.deliveryer_name,
item.delivery_date,
item.ticket_type);
dtGrid.Rows.Add(row);
cboEmployee.Text = item.receiver_name;
lblPageInfo.Text = "1/1";
btnPre.Enabled = false;
btnNext.Enabled = false;
}
}
}
catch (Exception)
{
}
}
private void txtSerieEnd_KeyUp(object sender, KeyEventArgs e)
{
try
{
lblMsg.Text = "";
string _serieStart = txtSerieStart.Text.Trim().ToUpper();
string _serieEnd = txtSerieEnd.Text.Trim().ToUpper();
if (_serieStart == "" || _serieEnd == "")
{
return;
}
string _ticketSerie = _serieStart.Substring(0, 10);
string _ticketType = _serieStart.Substring(8, 1);
int _sNum = Int32.Parse(_serieStart.Substring(10));
int _eNum = Int32.Parse(_serieEnd.Substring(10));
#region "check_input"
int rs = SystemHelp.CheckInputSerie(_serieStart, _serieEnd, _ticketSerie, _ticketType, _sNum, _eNum);
if (rs == 1)
{
lblMsg.Text = SystemMessage.WarningStartNumberErr;
return;
}
else if (rs == 2)
{
lblMsg.Text = SystemMessage.WarningTicketTypeErr;
return;
}
else if (rs == 3)
{
lblMsg.Text = SystemMessage.WarningMinMaxErr;
return;
}
else if (rs == 4)
{
lblMsg.Text = SystemMessage.WarningTicketTypeErr;
return;
}
#endregion
#region "create_dataRow"
// neu nhat nut them thi flag = 1 va neu chua co trong grid thi dua du lieu vao grid
// neu flag dang la 0 thi la tim kiem
if (_flag == 0)
{
_flag = 2;
} // dung co la dang tim ve
if (_flag == 1)
{
// neu nhap cua them moi
#region "get_infoticket"
center_ticket_type item = GetTicketId(_ticketSerie);
if (item == null)
{
lblMsg.Text = SystemMessage.WarningTableTicketTypeNull; return;
}
#endregion
#region "check_ticket_input"
var _tk = new center_ticket_store()
{
ticket_serie = _ticketSerie,
ticket_name = item.ticket_name,
ticket_type = item.id,
start_number_serie = _sNum,
end_number_serie = _eNum,
date_store = DateTime.Now,
date_out = DateTime.Now,
outForSale = false,
quantity = _eNum - _sNum + 1,
book_number = (_eNum - _sNum + 1) / 100,
};
// ktra da nhap vao grid chua
if (CheckSerieInDataRow(_tk))
{
lblMsg.Text = SystemMessage.WarningExitInputTicket;
return;
}
// ktra da nhap vao table chua
if (CheckSerieInTable(_tk))
{
lblMsg.Text = SystemMessage.WarningSaveTicket;
return;
}
#endregion
AddDataRow(_tk);
txtSerieStart.Text = "";
txtSerieEnd.Text = "";
txtSerieStart.Focus();
}
else if (_flag == 2)
{
// neu nhap la tim kiem
if (_pageTotal > 0)
{
var lst = FindTicketBySerie(_lstTicketStore, _ticketSerie, _sNum, _eNum);
int p = 0;
if (lst.Count > 0)
{
p = 1;
}
FillData(lst, p, 0, p);
_flag = 0;
}
}
#endregion
}
catch (Exception)
{
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
// khong in khi nhan nhap moi
if (_flag == 0 && dtGrid.Rows.Count > 0)
{
#region "commentCreateReport"
/*
* 1. Report la du lieu trong dtgrid
* 2. dtgrid du lieu cua cac loai ve chua gop nho, vi vay can lap de dua vao nhom
* 3. Bao cao se gom nhom tung loai ve, tinh tong vao phan tu dau tien
* 3. Lap het cac loai ve trong bang ve
* 4. bien tam de tinh tong so ve cua nhom ve dang lap,
* 5. khi lay du lieu o row nao trong dtgrid thi danh dau lai. de khong lap row cua dtgrid nua neu da lay het roi
* 6. Moi lan lap row cuar grid ma tim thay se tao doi tuong row trong bao cao roi dua vao list data report
* 7. Danh dau lai vi tri phan tu dau tien trong moi nhom ve o list data report
* 8. Dem so nhom ve cho bao cao de lam stt
*/
#endregion
List <RptTicketStoreModel> _lstDataReport = new List <RptTicketStoreModel>();
#region "convert_dataGrid_to_Report"
int _sumQuantity = 0; // tong so luong nhom ve trong report
int _counRowData = 0; // so row trong grid da duoc lay du lieu vao report, de k lap lai neu da het
int _sl = 0; // so ve trong tung row
RptTicketStoreModel _iRptTicketStoreModel; // 1 row trong list report
int _sttGroupTicket = 0; // so thu tu nhom ve trong report
int _indexItemRptDataReport = 0; // ptu dau tieng cua 1 nhom ve trong list datareport
// loop tung loai ve, so sanh voi tung row trong grid de tao du lieu cho report
foreach (center_ticket_type tkt in _lstTicketType)
{
if (_counRowData > dtGrid.Rows.Count - 1)
{
break;
} // neu da lay het du lieu cac dong trong dtgrid thi k loop nua
// vi tri nhom ve dau tien trong datareport. dung de tinh tong nhom ve
_indexItemRptDataReport = _lstDataReport.Count;
// loop tung row trong grid
foreach (DataGridViewRow row in dtGrid.Rows)
{
// neu tim thay ve thi dua vao list data report
if (tkt.id == row.Cells[8].Value.ToString())
{
_sl = Int32.Parse(row.Cells[5].Value.ToString());
_sumQuantity += _sl; // cong don tinh tong so ve theo loai
_iRptTicketStoreModel = new RptTicketStoreModel()
{
STT = -1,
LOAIVE = "",
DONGIA = -1,
SOLUONGTONG = -1,
SOLUONGSERIE = _sl,
SOSERIE = SystemHelp.Format_TicketSerie(row.Cells[2].Value.ToString(), row.Cells[3].Value.ToString(),
row.Cells[2].Value.ToString(), row.Cells[4].Value.ToString()),
TTIEN = -1
};
_lstDataReport.Add(_iRptTicketStoreModel);
_counRowData++;
}
}
// doi gia tri thang dau tien trong nhom ve
if (_sumQuantity != 0)
{
_sttGroupTicket++;
_lstDataReport[_indexItemRptDataReport].STT = _sttGroupTicket;
_lstDataReport[_indexItemRptDataReport].LOAIVE = tkt.ticket_name;
_lstDataReport[_indexItemRptDataReport].DONGIA = tkt.ticket_value;
_lstDataReport[_indexItemRptDataReport].SOLUONGTONG = _sumQuantity;
_lstDataReport[_indexItemRptDataReport].TTIEN = _sumQuantity * tkt.ticket_value;
_sumQuantity = 0;
}
}
#endregion
SplashScreenManager.ShowForm(typeof(FrmSplash));
RptTicketStore rpt = new RptTicketStore(_lstDataReport);
rpt.ShowReport();
SplashScreenManager.CloseForm();
}
}
catch (Exception)
{
}
}
public HelpCommand()
{
help = new SystemHelp();
}
