protected void btn_save_Click(object sender, EventArgs e)
{
if (passwordIsOk(txb_origPsw.Text))
{
if (txb_password.Text == txb_password_confirm.Text)
{
string pswMd5 = PasswordUtil.CreateDbPassword(txb_password.Text.Trim());
string sqlCmd = "update OA_Sys_EmployeeInfo set password='******' where id=" + GetUser();
SqlSel.ExeSql(sqlCmd);
SimpleForm1.Reset();
Alert.Show("密码修改完成！");
}
else
{
Alert.ShowInTop("两次输入的密码不一致！请重新输入。");
return;
}
}
else
{
Alert.ShowInTop("原密码不匹配！");
return;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (filePhoto.HasFile)
{
string fileName = filePhoto.ShortFileName;
if (!ValidateFileType(fileName))
{
Alert.Show("无效的文件类型！");
return;
}
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
fileName = DateTime.Now.Ticks.ToString() + "_" + fileName;
filePhoto.SaveAs(Server.MapPath("~/upload/" + fileName));
labResult.Text = "<p>用户名：" + tbxUseraName.Text + "</p>" +
"<p>头像：<br /><img src=\"" + ResolveUrl("~/upload/" + fileName) + "\" /></p>";
//// 清空表单字段（第一种方法）
//tbxUseraName.Reset();
//filePhoto.Reset();
// 清空表单字段（第三种方法）
SimpleForm1.Reset();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_PayMent_Main (reqMan,reqDte,payeeName,projId,FlowId,CurrentStepID,others,isAdvPay,payTotal) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "','" + txb_payeeName.Text + "','" + ddl_proj.SelectedValue + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + rdb_payType.SelectedValue + "','" + numbbox_total.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_PayMent_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_PayMent_Main", formId, "付款申请");
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(numbbox_days.Text) & string.IsNullOrEmpty(numbbox_hours.Text))
{
Alert.ShowInTop("天数和小时至少填一项。");
return;
}
//if (string.IsNullOrEmpty(hidden_field.Value))
//{
// Alert.Show("请先添加相应的文件，若已添加则确认可用！");
// return;
//}
decimal days = 0;
decimal hours = 0;
if (!string.IsNullOrEmpty(numbbox_days.Text))
{
days = Convert.ToDecimal(numbbox_days.Text);
}
if (!string.IsNullOrEmpty(numbbox_hours.Text))
{
hours = Convert.ToDecimal(numbbox_hours.Text);
}
string stepId = getStepId(ddl_flow.SelectedValue);//获取步骤id
string sqlCmd = "insert into OA_Leave_Main ([reqMan],[reqDte],[strTime],[endTime],[lastDays],[leaveReason],[FlowId],[CurrentStepID],[workReplacer],[lastHours]) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + DatePicker1.Text + " " + TimePicker1.Text + "','" + DatePicker2.Text + " " + TimePicker2.Text + "','" + days + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txb_replacer.Text.Trim() + "','" + hours + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Leave_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_Leave_Main", formId, "考勤申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_Bills_Main (reqMan,reqDte,billTotal,VoucherCount,FlowId,CurrentStepID,ReqReason,RelProj,ProveEmp) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + numbbox_total.Text.Trim() + "','" + numbbox_count.Text.Trim() + "',";
sqlCmd += "'" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + ddl_proj.SelectedValue + "','" + txa_proveList.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Bills_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
//插入关联费用项
string[] selectValueArray = ckbl_costItems.SelectedValueArray;
foreach (string item in selectValueArray)
{
sqlCmd = "insert into OA_Bills_RelCostItems ([formId],[CostItemId]) values (";
sqlCmd += "'" + formId + "','" + item + "')";
SqlSel.ExeSql(sqlCmd);
}
//插入证明人表
//if (!string.IsNullOrEmpty(txa_proveList.Text))
//{
// insertProveList(txa_proveList.Text, formId);
//}
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_Bills_Main", formId, "费用报销");
}
}
else
{
Alert.Show("请先添加相应的文件，若已添加则确认可用！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(recvId))
{
string sqlCmd = "insert into OA_Sys_Step_Emp (stepId,deptId,dutyId) values ( ";
sqlCmd += "'" + recvId + "','" + ddl_dept.SelectedValue + "','" + ddl_duty.SelectedValue + "')";
SqlSel.ExeSql(sqlCmd);
Alert.ShowInParent("保存成功，请关闭当前窗口查看。");
SimpleForm1.Reset();
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(recvId))
{
string sqlCmd = "insert into OA_Sys_Flow_Step (flowId,stepName,stepOrderNo) values (";
sqlCmd += "'" + recvId + "','" + txb_stepName.Text.Trim() + "','" + getMaxSort() + "')";
SqlSel.ExeSql(sqlCmd);
Alert.ShowInParent("编辑成功，请退出当前窗口！");
SimpleForm1.Reset();
//PageContext.RegisterStartupScript(ActiveWindow.GetHideReference());
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList();
if (newAddedList.Count > 0)
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_OfficeSupply_Main (reqMan,reqDte,FlowId,CurrentStepID,others) values ('" + GetUser() + "','" + DateTime.Now + "',";
sqlCmd += "'" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_OfficeSupply_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入申请明细
for (int i = 0; i < newAddedList.Count; i++)
{
string propertyName = newAddedList[i]["propertyName"].ToString();
string propertyNo = propertyName.Substring(0, propertyName.IndexOf("-"));
sqlCmd = "insert into OA_OfficeSupply_applyItem (officeSupplyId,propertyNo,applyCounts,applyUnit) values ('" + formId + "','" + propertyNo + "',";
sqlCmd += "'" + Convert.ToDecimal(newAddedList[i]["applyCounts"]) + "','" + newAddedList[i]["applyUnit"] + "')";
SqlSel.ExeSql(sqlCmd);
}
Alert.Show("提交成功！");
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
pushMessage(stepId, "OA_OfficeSupply_Main", formId, "办公用品申请");
}
else
{
Alert.ShowInTop("提交失败！");
return;
}
}
else
{
Alert.ShowInTop("尚未添加申领物品，不可提交！");
return;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_Fines_Main (reqMan,reqDte,fineAmount,FlowId,CurrentStepID,ReqReason,projId,Objects,ProveEmp) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + numbbox_total.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + ddl_proj.SelectedValue + "','" + txa_empList.Text + "','" + txa_proveList.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Fines_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
//插入被处罚对象
//if (!string.IsNullOrEmpty(txa_empList.Text))
//{
// insertObjList(txa_empList.Text, formId);
//}
////插入证明人表
//if (!string.IsNullOrEmpty(txa_proveList.Text))
//{
// insertProveList(txa_proveList.Text, formId);
//}
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_Fines_Main", formId, "处罚流程");
}
}
else
{
Alert.Show("请先添加相应图片凭据！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
//插入附件信息
private void InsertFiles(string definedName)
{
string access_token = VerifyLegal.GetAccess_Token();//获取access_token
string sqlCmd = "";
string fileList = hidden_field.Value;
//解析明细Id
String[] str = fileList.Split(';');
int sortIndex = 0;//文件名后缀
foreach (string it in str)
{
if (it == "")
{
break;
}
sortIndex = sortIndex + 1;
string fileName = GetMultimedia(access_token, it, "/upload");
sqlCmd = "insert into OA_DocMgmt_DocList (docName,docTyp,docStat,subman,subDte,doc_leng,docPath) values ";
sqlCmd += "('" + definedName + "-" + sortIndex.ToString() + "','" + ddl_docType.SelectedValue + "',1,'" + curUserId + "','" + DateTime.Now + "',";
sqlCmd += "'" + ddl_proj.SelectedValue + "','" + fileName + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount == 0)
{
Alert.ShowInTop("上传出错！");
return;
}
else
{
//插入其他文件信息
sqlCmd = "select max(id) from OA_DocMgmt_DocList";
int docId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
sqlCmd = "insert into OA_DocMgmt_Propety (docId,docSN,AgreementPaty,SubjectMatter,AgreeAmount,AmountType,StartDate,EndDate,Remarks) values ";
sqlCmd += "('" + docId + "','" + txb_docSN.Text + "','" + txa_AgreementPaty.Text + "','" + txa_SubjectMatter.Text + "','" + numb_amount.Text + "',";
sqlCmd += "'" + txb_AmountType.Text + "','" + DatePicker1.Text + "','" + DatePicker2.Text + "','" + txa_Remarks.Text + "')";
SqlSel.ExeSql(sqlCmd);
}
}
Alert.Show("文件全部上传成功！");
//表单重置
SimpleForm1.Reset();
}
protected void btn_save_Click(object sender, EventArgs e)
{
string sqlCmd = "";
if (string.IsNullOrEmpty(recvId))
{
sqlCmd = "insert into OA_sys_Project (ProjName,FoundTime,ProjStatus,ProjDesc,workSpace,projItems,workFor,projAmount,workArea) values (";
sqlCmd += "'" + txb_ProjName.Text + "','" + DateTime.Now + "','" + rdbl_status.SelectedValue + "','" + txa_ProjDesc.Text + "',";
sqlCmd += "'" + txa_workSpace.Text + "','" + txa_projItems.Text + "','" + txb_WorkFor.Text + "','" + numb_amount.Text + "','" + Numb_workArea.Text + "')";
SimpleForm1.Reset();
}
else
{
sqlCmd = "update OA_sys_Project set ProjName='" + txb_ProjName.Text + "',ProjStatus='" + rdbl_status.SelectedValue + "',ProjDesc='" + txa_ProjDesc.Text + "',";
sqlCmd += "workSpace='" + txa_workSpace.Text + "',projItems='" + txa_projItems.Text + "',workFor='" + txb_WorkFor.Text + "',projAmount='" + numb_amount.Text + "',workArea='" + Numb_workArea.Text + "' where id=" + recvId;
}
SqlSel.ExeSql(sqlCmd);
Alert.Show("保存成功！请关闭当前窗口。");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string stepId = getStepId(ddl_flow.SelectedValue);
string sqlCmd = "insert into OA_PayMent_Main (reqMan,reqDte,payeeName,payTotal,projId,FlowId,CurrentStepID,others,isAdvPay) values ";
sqlCmd += "('" + curUserId + "','" + DateTime.Now + "','" + txb_payeeName.Text + "','" + numbbox_total.Text + "','" + ddl_proj.SelectedValue + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + txa_reason.Text + "','" + rdb_payType.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_PayMent_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
PageContext.RegisterStartupScript("clearImg()");
//推送信息至相关审批人
pushMessage(stepId, "OA_PayMent_Main", formId, "付款申请");
}
}
else
{
Alert.ShowInTop("请先上传相应附件后再提交！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string stepId = getStepId(RadioButtonList1.SelectedValue);//获取步骤id
string sqlCmd = "insert into OA_UseStamp_Main ([reqMan],[reqDte],[useFor],[FlowId],[CurrentStepID],[stampType]) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + RadioButtonList1.SelectedValue + "','" + stepId + "','" + RadioButtonList1.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_UseStamp_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_UseStamp_Main", formId, "用印申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void btnUpdateSelected_Click(object sender, EventArgs e)
{
// 在操作之前进行权限检查
if (!CheckPower("HcView"))
{
CheckPowerFailWithAlert();
return;
}
int ID = GetSelectedDataKeyID(Grid1);
if (ID != -1)
{
//保存工卡信息
Hc h = DB.Hcs.Where(u => u.ID == ID).FirstOrDefault();
h.part_name = tbx_part_name.Text;
h.pn = tbx_pn.Text;
h.sn = tbx_sn.Text;
h.part_type = DropDownList_Part_Type.SelectedValue;
h.condition = DropDownList_Condition.SelectedValue;
h.loc = tbx_loc.Text;
h.onhand = Convert.ToInt32(tbx_onhand.Text);
h.part_des = tbx_des.Text;
h.remark = tbx_remark.Text;
h.rec_date = Convert.ToDateTime(tbx_rec_date.Text);
DB.SaveChanges();
Alert.Show("航材数据更新成功！");
SimpleForm1.Reset();
BindGrid1();
}
else
{
Alert.Show("请选择要更新的航材！");
}
}
protected void btnRest_Click(object sender, EventArgs e)
{
SimpleForm1.Reset();
BindGrid();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string stepId = getStepId(ddl_flow.SelectedValue); //获取步骤id
string sqlCmd = "";
if (checkBox_personal.Checked == true) //个人用车
{
sqlCmd = "insert into OA_Car_Main ([reqMan],[reqDte],[carNumb],[curMileage],[withWho],[useReason],[FlowId],[CurrentStepID],[useDate],[backTime],[toWhere],[projId]) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "','" + txb_carNumb.Text.Trim() + "','" + numbbox_curMileage.Text + "','" + txb_withWho.Text + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + DatePicker1.Text + " " + TimePicker1.Text + "',";
sqlCmd += "'" + DatePicker2.Text + " " + TimePicker2.Text + "','" + txb_toWhere.Text + "','" + ddl_proj.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//取当前单据id
sqlCmd = "select max(id) from OA_Car_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_Car_Main", formId, "用车申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
else //单位用车
{
sqlCmd = "insert into OA_Car_Main ([reqMan],[reqDte],[deptCarId],[curMileage],[withWho],[useReason],[FlowId],[CurrentStepID],[useDate],[backTime],[toWhere],[projId]) values ";
sqlCmd += "('" + GetUser() + "','" + DateTime.Now + "','" + ddl_carList.SelectedValue + "','" + numbbox_curMileage.Text + "','" + txb_withWho.Text + "',";
sqlCmd += "'" + TextArea_desc.Text.Trim() + "','" + ddl_flow.SelectedValue + "','" + stepId + "','" + DatePicker1.Text + " " + TimePicker1.Text + "',";
sqlCmd += "'" + DatePicker2.Text + " " + TimePicker2.Text + "','" + txb_toWhere.Text + "','" + ddl_proj.SelectedValue + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount > 0)
{
//更新单位车辆征用状态
sqlCmd = "update OA_Property_Register set OnUsing='1' where id='" + ddl_carList.SelectedValue + "'";
SqlSel.ExeSql(sqlCmd);
//取当前单据id
sqlCmd = "select max(id) from OA_Car_Main";
string formId = SqlSel.GetSqlScale(sqlCmd).ToString();
//插入附件信息表
InsertFiles(formId);
Alert.Show("提交成功！");
//表单重置
SimpleForm1.Reset();
Grid1.DataSource = null;
Grid1.DataBind();
//推送信息至相关审批人
pushMessage(stepId, "OA_Car_Main", formId, "用车申请");
}
else
{
Alert.Show("提交失败！");
return;
}
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}