protected void bindGrid()
{
try
{
DataTable dt = new DataTable();
string sqlCmd = "select * from OA_Bills_costLists where [bStatus]='1' order by id";
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid1.DataSource = dt;
Grid1.DataBind();
sqlCmd = "select max(id) from OA_Bills_costLists";
string curMaxId = SqlSel.GetSqlScale(sqlCmd).ToString();
if (string.IsNullOrEmpty(curMaxId))
{
label_hidden.Text = "0";
}
else
{
label_hidden.Text = curMaxId;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
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 bindGrid()
{
try
{
DataTable dt = new DataTable();
string sqlCmd = "select * from OA_Property_Register order by BuyDate desc";
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid1.DataSource = dt;
Grid1.DataBind();
sqlCmd = "select max(id) from OA_Property_Register";
string curMaxId = SqlSel.GetSqlScale(sqlCmd).ToString();
if (string.IsNullOrEmpty(curMaxId))
{
label_hidden.Text = "0";
}
else
{
label_hidden.Text = curMaxId;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
//添加表格页脚打印信息
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
string printUser = "";
string sqlCmd = "select chinesename from x_user where name='" + GetUser() + "'";
printUser = SqlSel.GetSqlScale(sqlCmd).ToString();
if (e.Row.RowType == DataControlRowType.Footer)
{
//e.Row.Cells[0].ColumnSpan = e.Row.Cells.Count;
//e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
//e.Row.Cells[0].Text = "打印人:" + GetUser() + " | 打印时间:" + DateTime.Now;
TableCell oldTc = e.Row.Cells[0];
for (int i = 1; i < e.Row.Cells.Count; i++)
{
TableCell tc = e.Row.Cells[i];
if (oldTc.Text == tc.Text)
{
tc.Visible = false;
if (oldTc.ColumnSpan == 0)
{
oldTc.ColumnSpan = 1;
}
oldTc.ColumnSpan++;
//oldTc.VerticalAlign = VerticalAlign.Middle;
}
else
{
oldTc = tc;
}
}
oldTc.Text = "打印人:" + printUser + " | 打印时间:" + DateTime.Now;
oldTc.HorizontalAlign = HorizontalAlign.Right;
}
}
private string getStepId(string flowId)
{
string sqlCmd = "select id from OA_Sys_Flow_Step where flowid='" + flowId + "' and stepOrderNo=1";
string stepId = SqlSel.GetSqlScale(sqlCmd).ToString();
return(stepId);
}
protected void bindGrid()
{
try
{
DataTable dt = new DataTable();
string sqlCmd = "select * from OA_DocMgmt_DocType where pid='0' and stat=1 order by type_name";
SqlSel.GetSqlSel(ref dt, sqlCmd);
Grid1.DataSource = dt;
Grid1.DataBind();
sqlCmd = "select max(id) from OA_DocMgmt_DocType";
string curMaxId = SqlSel.GetSqlScale(sqlCmd).ToString();
if (string.IsNullOrEmpty(curMaxId))
{
label_hidden.Text = "0";
}
else
{
label_hidden.Text = curMaxId;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
//提交
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(RadioButtonList_goal.SelectedValue))
{
string sqlcmd = "update T_DailyWork set LeaderGrade=" + Convert.ToInt32(RadioButtonList_goal.SelectedValue) + ",LeaderGradeReason='" + TextArea_context.Text + "' where Id=" + tabId + " ";
int exeCount = SqlSel.ExeSql(sqlcmd);
if (exeCount > 0)
{
//将审批结果反馈给相关人员
string messageContent = string.Format("工作评分：{0}分\\n领导寄语：{1}", RadioButtonList_goal.SelectedValue, TextArea_context.Text);
sqlcmd = "select cellPhone from x_user where name='" + label_hidden.Text + "'";
string targetNum = SqlSel.GetSqlScale(sqlcmd).ToString();
if (!string.IsNullOrEmpty(targetNum))
{
WX2HK.ReturnInfo.messagePushByNum(targetNum + ";", string.Format("{0}-工作情况", label_date.Text), "", messageContent, "");
}
//Alert.Show("提交成功！");
btnSubmit.Hidden = true;
// 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
}
else
{
Alert.ShowInTop("请打分!");
return;
}
}
//排产数据的添加
private void infoInsert()
{
string curUser = GetUser();
if (!string.IsNullOrEmpty(curUser))
{
int isTempOrder = 0;
if (CkeckBox_enabled.Checked)
{
isTempOrder = 1;
}
string ImgURL = label_hidden.Text;
string sqlCmd = "insert into [PLM_Product_OnLine] ([LineId],[OrderId],[BuildTime],[OnlineStatus],[OperUser] ,[PlanCount] ,[IsTemp] ,[OrderNo] ,[ItemParm] ,[ItemName],[ItemNo],[RedLineCount],[PreSetCount],[ItemTech])";
sqlCmd += " values ('" + ddl_line.SelectedValue + "','" + Label_sn.Text + "','" + DateTime.Now + "',1,'" + curUser + "','" + numb_planCount.Text + "','" + isTempOrder + "',";
sqlCmd += "'" + txb_workNo.Text + "','" + TextArea_parm.Text + "','" + txb_itemName.Text + "','" + txb_itemNo.Text + "','" + numb_redCount.Text + "','" + numb_preSet.Text + "','" + txb_itemTech.Text + "')";
SqlSel.ExeSql(sqlCmd);
sqlCmd = "select max(id) from PLM_Product_OnLine";
int onlineId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
sqlCmd = "insert into PLM_Product_Image (OnlineId,ImgURL) values ";
sqlCmd += "('" + onlineId + "','" + ImgURL + "')";
SqlSel.ExeSql(sqlCmd);
//执行关联明细信息的数据插入(单条)
string sqlStr = "insert into PLM_Product_Rel (orderid,ProdId,PriLevel,OrderCount) values ";
sqlStr += "('" + Label_sn.Text + "','" + onlineId + "',1,'" + numb_redCount.Text + "')";
SqlSel.ExeSql(sqlStr);
Alert.ShowInTop("操作成功！");
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
}
/// <summary>
/// 根据表单类型和岗位加载可用流程
/// </summary>
/// <param name="formName">表单类型名称</param>
/// <param name="userId">用户id</param>
/// <returns>流程相关信息</returns>
public static DataTable validFlow(string formName, string userId)
{
//表单关联所有流程
string sqlCmd = "select B.flowName,B.id from OA_Sys_FlowRelForm A left join OA_sys_flow B on A.flowId=B.id where A.formDataName='" + formName + "' and B.isUsed='1'";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
//获取登录用户岗位
sqlCmd = "select dutyId from OA_Sys_EmployeeInfo where id='" + userId + "'";
string userDuty = SqlSel.GetSqlScale(sqlCmd).ToString();
//遍历流程，没有指定岗位的显示，指定岗位但人员不在列的不显示
for (int rowIndex = 0; rowIndex < dt.Rows.Count; rowIndex++)
{
string compFlowId = dt.Rows[rowIndex]["id"].ToString();
sqlCmd = "select * from OA_Sys_FlowRelDuty where flowId='" + compFlowId + "'";
DataTable tempDt = new DataTable();
SqlSel.GetSqlSel(ref tempDt, sqlCmd);
if (tempDt.Rows.Count > 0)
{
DataRow[] findRow = tempDt.Select("dutyId='" + userDuty + "' ");
if (findRow.Length == 0)
{
dt.Rows.RemoveAt(rowIndex);
}
}
}
return(dt);
}
protected void btn_sub_Click(object sender, EventArgs e)
{
try
{
if (Grid1.Rows.Count > 0)
{
for (int i = 0; i < Grid1.Rows.Count; i++)
{
GridRow grow = Grid1.Rows[i];
if (string.IsNullOrEmpty(((System.Web.UI.WebControls.TextBox)grow.FindControl("tbxWorkDtl")).Text))
{
Alert.ShowInTop("工作内容不可为空！");
return;
}
}
string sqlCmd = "";
sqlCmd = "insert into T_DailyWork (ReqDte,WorkDte,WorkNo,SelfGrade,Stat) values";
sqlCmd += "('" + DateTime.Now + "','" + label_date.Text + "','" + curUser + "'," + Convert.ToInt32(RadioButtonList_goal.SelectedValue) + ",11)";
SqlSel.ExeSql(sqlCmd);
sqlCmd = "select max(Id) from T_DailyWork where workno='" + curUser + "'";
int maxId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
for (int i = 0; i < Grid1.Rows.Count; i++)
{
GridRow grow = Grid1.Rows[i];
sqlCmd = "insert into T_Work_Detail_Record";
sqlCmd += "(MainID,WorkDetail,WorkProcess,Mark) values";
sqlCmd += "(" + maxId + ",'" + ((System.Web.UI.WebControls.TextBox)grow.FindControl("tbxWorkDtl")).Text + "',100,'" + Grid1.Rows[i].Values[0].ToString() + "')";
SqlSel.ExeSql(sqlCmd);
}
//推送相关提交信息
sqlCmd = "select CellPhone from x_user where name=(select rz_parentid from view_rs_employeeinfo where gh_id='" + curUser + "')";
string targetNum = SqlSel.GetSqlScale(sqlCmd).ToString();
string messageContent = string.Format("来自{0}的工作汇报", label_name.Text);
if (!string.IsNullOrEmpty(targetNum))
{
string url = string.Format("https://open.weixin.qq.com/connect/oauth2/authorize?appid=wxc1c3336a5eeb57ea&redirect_uri=http%3a%2f%2foa.mlily.com%3a30020%2fdailyWork%2fdailyWork_leaderView.aspx?mainId={0}&response_type=code&scope=SCOPE&state=STATE#wechat_redirect", maxId);
WX2HK.ReturnInfo.messagePushByNum(targetNum + ";", string.Format("{0}-工作汇报", label_date.Text), url, messageContent, "");
}
Alert.Show("提交成功！");
PageContext.RegisterStartupScript(SimpleForm1.GetResetReference());
Grid1.Reset();
btnSubmit.Hidden = true;
}
else
{
Alert.ShowInTop("请填写相关工作内容后再提交！");
return;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}
private void loadUserInfo(string LoginUserId)
{
string sqlCmd = "select chineseName from OA_Sys_EmployeeInfo where id='" + LoginUserId + "' ";
string curUser = SqlSel.GetSqlScale(sqlCmd).ToString();
//label_userInfo.Text = curUser + "，欢迎登陆.";
div_member.InnerText = curUser + "，欢迎登陆.";
}
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 autoLogistics(string shopId)
{
//DataTable dt1 = new DataTable();
//string sqlcmd="select [TradeStatus],[TradeNO],[ShopID],(select [Name] FROM [mbh_wdgj31].[dbo].[G_Cfg_LogisticList] where [G_Trade_TradeList].LogisticID= [G_Cfg_LogisticList].LogisticID) as [LogisticName]"
// +" ,[PostID],[TradeNO2] from [mbh_wdgj31].[dbo].[G_Trade_TradeList] "
// +" where [ShopID]='1029' and [TradeStatus]=11 and [TradeNO2] like '%-%' "
// + " and [TradeNO]>(select top 1 max([TradeNO]) from WDApiFH ) and TradeFrom='蜘蛛'";
//取已同步的最大发货时间前1天所有数据去重并同步
string sqlcmd = "select [TradeStatus],[TradeNO],[ShopID],[sndtime],(select [Name] FROM"
+ " [mbh_wdgj31].[dbo].[G_Cfg_LogisticList] where [G_Trade_TradeList].LogisticID= [G_Cfg_LogisticList].LogisticID) as [LogisticName]"
+ " ,[PostID],[TradeNO2],(select nickName from g_customer_customerlist where G_Trade_TradeList.customerId=g_customer_customerlist.customerId) as nickName"
+ " from [mbh_wdgj31].[dbo].[G_Trade_TradeList] where [ShopID]='" + shopId + "' and [TradeStatus]=11"
+ " and sndTime>dateadd(day,-1,ISNULL((select max(sendtime) from WDApiFH where cipher='" + shopId + "'),'2017-09-01'))"
+ " and TradeFrom='蜘蛛'";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlcmd);
StringBuilder sb = new StringBuilder();
try
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string LogisticName = dt.Rows[i]["LogisticName"].ToString();
string PostID = dt.Rows[i]["PostID"].ToString();
string orderid = dt.Rows[i]["TradeNO2"].ToString();
string tradeNo = dt.Rows[i]["TradeNO"].ToString();
string sendTime = Convert.ToDateTime(dt.Rows[i]["sndTime"]).ToString("yyyy-MM-dd HH:mm:ss.fff");
string nickName = dt.Rows[i]["nickName"].ToString();
sb.Append(mSndGoods(orderid, LogisticName, PostID, nickName, tradeNo, sendTime, shopId));
}
Label1.Text = sb.ToString();
sqlcmd = "select isnull(max(rqtid),0) from wdapifh where cipher='" + shopId + "' ";
int curId = Convert.ToInt32(SqlSel.GetSqlScale(sqlcmd));
//记录自动执行日志
sqlcmd = "insert into t_sfy_autoExecLog (execTime,execCount,shopId) values ('" + DateTime.Now + "'," + curId + ",'" + shopId + "')";
SqlSel.ExeSql(sqlcmd);
Label_status.Text = string.Format("{0},【1039】同步物流信息完成。", DateTime.Now);
//同步记录前台更新
reloadLog();
}
catch (Exception ex)
{
Label_status.Text = ex.Message;
Timer2.Enabled = false;
}
//dt1.DataSet.Clear();
}
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);
}
}
//获取菜单序列号
private int getSortIndex(string parentId)
{
int sortIndex = 0;
DataTable dt = new DataTable();
string sqlCmd = "select max(sortIndex) from OA_Sys_Menu where ParentMenuId='" + parentId + "'";
string res = SqlSel.GetSqlScale(sqlCmd).ToString();
if (!string.IsNullOrEmpty(res))
{
sortIndex = Convert.ToInt32(res);
}
return(sortIndex);
}
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);
}
}
//验证与原密码是否匹配
private bool passwordIsOk(string inputStr)
{
string sqlCmd = "select password from OA_Sys_EmployeeInfo where id='" + GetUser() + "'";
string dbPsw = SqlSel.GetSqlScale(sqlCmd).ToString();
if (PasswordUtil.ComparePasswords(dbPsw, inputStr))
{
return(true);
}
else
{
return(false);
}
}
//判断当前人员是否有页面审批权限
private bool haveNoCheckPrivilege(int mainId, string loginUser)
{
string sqlCmd = "select rz_parentid from view_rs_employeeinfo where gh_id=(select workno from t_dailywork where id=" + mainId + ")";
string rz_parentid = SqlSel.GetSqlScale(sqlCmd).ToString();//拥有审批权限的工号
if (loginUser != rz_parentid)
{
return(true);
}
else
{
return(false);
}
}
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);
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
string sqlCmd = "";
int userStatus = ckeckBox_enabled.Checked ? 1 : 0;
if (string.IsNullOrEmpty(recvId))
{
sqlCmd = "insert into OA_Sys_EmployeeInfo (loginId,password,chineseName,deptId,dutyId,useStatus,phoneNumber) values (";
sqlCmd += "'" + txb_loginID.Text + "','" + PasswordUtil.CreateDbPassword("123456") + "','" + txb_chineseName.Text + "',";
sqlCmd += "'" + ddl_depart.SelectedValue + "','" + ddl_duty.SelectedValue + "','" + userStatus + "','" + numbb_phoneNumb.Text + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);
if (exeCount == 1)
{
sqlCmd = "select max(id) from OA_Sys_EmployeeInfo";
string newUserId = SqlSel.GetSqlScale(sqlCmd).ToString();
//更新角色信息
string[] selectValueArray = ckb_roleList.SelectedValueArray;
foreach (string item in selectValueArray)
{
sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values (";
sqlCmd += "'" + newUserId + "','" + item + "','" + DateTime.Now + "')";
SqlSel.ExeSql(sqlCmd);
}
}
}
else
{
sqlCmd = "update OA_Sys_EmployeeInfo set loginId='" + txb_loginID.Text + "',chineseName='" + txb_chineseName.Text + "',deptId='" + ddl_depart.SelectedValue + "',";
sqlCmd += "dutyId='" + ddl_duty.SelectedValue + "',useStatus='" + userStatus + "',phoneNumber='" + numbb_phoneNumb.Text + "' where id=" + recvId;
SqlSel.ExeSql(sqlCmd);
//删除用户现有角色
sqlCmd += "delete from OA_Sys_UserRole where userid=" + recvId;
SqlSel.ExeSql(sqlCmd);
string[] selectValueArray = ckb_roleList.SelectedValueArray;
foreach (string item in selectValueArray)
{
sqlCmd = "insert into OA_Sys_UserRole (userid,roleid,addtime) values (";
sqlCmd += "'" + recvId + "','" + item + "','" + DateTime.Now + "')";
SqlSel.ExeSql(sqlCmd);
}
}
Alert.ShowInTop("保存成功！");
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
//插入附件信息
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();
}
//排产数据的添加
private void infoInsert()
{
string curUser = GetUser();
if (!string.IsNullOrEmpty(curUser))
{
int isTempOrder = 0;
if (CkeckBox_enabled.Checked)
{
isTempOrder = 1;
}
string ImgURL = label_hidden.Text;
if (!filePhoto.HasFile)
{
ImgURL = "636195999216328808_84U58PICkTn.jpg";//设置默认图片
}
string sqlCmd = "insert into [PLM_Product_OnLine] ([LineId],[BuildTime],[OnlineStatus],[OperUser] ,[PlanCount] ,[IsTemp] ,[OrderNo] ,[ItemParm] ,[ItemName],[ItemNo],[RedLineCount],[PreSetCount],[ItemTech])";
sqlCmd += " values ('" + ddl_line.SelectedValue + "','" + DateTime.Now + "',1,'" + curUser + "','" + numb_planCount.Text + "','" + isTempOrder + "',";
sqlCmd += "'" + txb_workNo.Text + "','" + TextArea_parm.Text + "','" + txb_itemName.Text + "','" + txb_itemNo.Text + "','" + numb_redCount.Text + "','" + numb_preSet.Text + "','" + txb_itemTech.Text + "')";
SqlSel.ExeSql(sqlCmd);
sqlCmd = "select max(id) from PLM_Product_OnLine";
int onlineId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
sqlCmd = "insert into PLM_Product_Image (OnlineId,ImgURL) values ";
sqlCmd += "('" + onlineId + "','" + ImgURL + "')";
SqlSel.ExeSql(sqlCmd);
//string find = "";
if (!CkeckBox_enabled.Checked)//如果不是临时插单，不插入关联信息
{
for (int i = 0; i < Grid_hidden.Rows.Count; i++)
{
//获取合并的订单信息
int recId = Convert.ToInt32(Grid_hidden.Rows[i].Values[0]);
int orderCount = Convert.ToInt32(Grid_hidden.Rows[i].Values[1]);
//执行关联明细信息的数据插入
string sqlStr = "insert into PLM_Product_Rel (orderid,ProdId,PriLevel,OrderCount) values ";
sqlStr += "('" + recId + "','" + onlineId + "',1,'" + orderCount + "')";
SqlSel.ExeSql(sqlStr);
}
}
//表单重置
PageContext.RegisterStartupScript(Region2.GetResetReference());
Alert.ShowInTop("操作成功！");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//更新加班申请表状态
DateTime spDte = System.DateTime.Now;
String sqlCmd = "update T_Overtime set Stat = '1' where Id = " + tabId + "";
SqlSel.ExeSql(sqlCmd);
//更新审批状态
sqlCmd = "update T_SpFollow set Checked = '1',CheckeDte = '" + spDte + "' where tabId = " + tabId + " and spTyp = '1'";
SqlSel.ExeSql(sqlCmd);
//写入考勤数据库
sqlCmd = "INSERT INTO [HKKQ_real].[dbo].[KQ_b_Addban] ";
sqlCmd += "([YhBH] ,[StartRqSj] ,[EndRqSj],[czy] ,[rq],[typ],[times])";
sqlCmd += "(select yhbh,reqdt1,reqdt2,reqman,Convert(char(10),reqdte,120),addfunc,ADDTIME from T_Overtime,rs_qjandjb_subdtl ";
sqlCmd += "where T_Overtime.id= " + tabId + " and typ=1 and rs_qjandjb_subdtl.mainid= " + tabId + ")";
SqlSel.ExeSql(sqlCmd);
//Alert.ShowInTop("审批完成！");
//审批按钮隐藏
btnSubmit.Hidden = true;
//将考勤结果反馈给部门考勤员
sqlCmd = "select x_user.cellPhone from ";
sqlCmd += "(select a.gh_id from view_banzhi_rsRole a inner join view_rs_employeeinfo b on a.departid=b.departid and b.gh_id=(select reqman from T_Overtime where id=" + tabId + ")) c ";
sqlCmd += "left join x_user on x_user.name=c.gh_id";
string notifyTarget = SqlSel.GetSqlScale(sqlCmd).ToString();
//抄送信息至部门相关考勤员
string messageContent = string.Format("加班人员：{0}\\n加班时长：{3} \\n起始时间：{1} \\n截止时间：{2} ", label_personDtl.Text, label_startTime.Text, label_endTime.Text, label_hours.Text);
if (!string.IsNullOrEmpty(notifyTarget))
{
WX2HK.ReturnInfo.messagePushByNum(notifyTarget + ";", "加班登记", "", messageContent, "");
}
// 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
//判断当前人员是否有页面审批权限
//private bool haveNoCheckPrivilege(string mainId)
//{
// string sqlCmd = "select WorkNo from T_SpFollow where tabId=" + mainId + " and spTyp = '2'";
// string spMan = SqlSel.GetSqlScale(sqlCmd).ToString();//拥有审批权限的工号
// //if (spMan != curWorkNo)
// //{
// // return true;
// //}
// //else
// //{
// // return false;
// //}
//}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//更新审批表
String sqlCmd = "update T_SpFollow set Checked = '1',CheckeDte = '" + DateTime.Now + "' where tabId = " + tabId + " and spTyp = '2'";
SqlSel.ExeSql(sqlCmd);
//更新请假单状态
sqlCmd = "update T_LeaveReq set Stat = '1' where Id = " + tabId + "";
SqlSel.ExeSql(sqlCmd);
//Alert.ShowInTop("审批完成！");
//将考勤结果反馈给部门考勤员
sqlCmd = "select x_user.cellPhone from ";
sqlCmd += "(select a.gh_id from view_banzhi_rsRole a inner join view_rs_employeeinfo b on a.departid=b.departid and b.gh_id=(select reqman from T_LeaveReq where id=" + tabId + ")) c ";
sqlCmd += "left join x_user on x_user.name=c.gh_id";
string notifyTarget = SqlSel.GetSqlScale(sqlCmd).ToString();
//抄送信息至部门相关考勤员
string messageContent = string.Format("请假人员：{0}\\n天数：{3} \\n小时：{4} \\n起始时间：{1} \\n截止时间：{2} ", label_personDtl.Text, label_startTime.Text, label_endTime.Text, label_days.Text, label_hours.Text);
if (!string.IsNullOrEmpty(notifyTarget))
{
WX2HK.ReturnInfo.messagePushByNum(notifyTarget + ";", "请假登记", "", messageContent, "");
}
//审批按钮隐藏
btnSubmit.Hidden = true;
//写入考勤数据库
sqlCmd = "INSERT INTO [HKKQ_real].[dbo].[KQ_b_Leave] ";
sqlCmd += "([YhBH],[StartRqSj],[EndRqSj],[Hours],[Days],[Cause],[Memo],[czy]) ";
sqlCmd += "(select yhbh,leavedt1,leavedt2,hours,days,T_LeaveReq.typ,addfunc,reqman from T_LeaveReq,rs_qjandjb_subdtl ";
sqlCmd += "where T_LeaveReq.id= " + tabId + " and rs_qjandjb_subdtl.typ=2 and rs_qjandjb_subdtl.mainid= " + tabId + ")";
SqlSel.ExeSql(sqlCmd);
// 关闭本窗体，然后刷新父窗体
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
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_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);
}
}
/// <summary>
/// 插入节点审批对象并推送相关微信信息
/// </summary>
/// <param name="stepId">审批步骤id</param>
/// <param name="tableName">表单数据库表名</param>
/// <param name="formId">表单id</param>
/// <param name="MessageName">审批类型名称</param>
public static void pushMessage(string stepId, string tableName, string formId, string MessageName)
{
StringBuilder sb = new StringBuilder();
string sqlCmd = "select * from OA_Sys_Step_Emp where stepId='" + stepId + "'";
DataTable dt = new DataTable();
SqlSel.GetSqlSel(ref dt, sqlCmd);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string deptId = dt.Rows[i]["deptId"].ToString();
string dutyId = dt.Rows[i]["dutyId"].ToString();
if (deptId == "0") //申请人本部门
{
sqlCmd = "select deptId from OA_Sys_EmployeeInfo where id=(select reqman from " + tableName + " where id='" + formId + "')";
deptId = SqlSel.GetSqlScale(sqlCmd).ToString();
}
DataTable dtNodeUserList = new DataTable();
sqlCmd = "select id from OA_Sys_EmployeeInfo where deptid='" + deptId + "' and dutyId='" + dutyId + "' and useStatus='1'";
SqlSel.GetSqlSel(ref dtNodeUserList, sqlCmd);
for (int j = 0; j < dtNodeUserList.Rows.Count; j++)
{
sqlCmd = "insert into OA_Sys_step_empList (stepId,userId,formId,formDataName,formName) values ('" + stepId + "','" + dtNodeUserList.Rows[j]["id"].ToString() + "',";
sqlCmd += "'" + formId + "','" + tableName + "','" + MessageName + "')";
int exeCount = SqlSel.ExeSql(sqlCmd);//插入节点审批人员明细表
//插入成功则向相关人员的微信推送消息
if (exeCount > 0)
{
sb.AppendFormat("{0}|", dtNodeUserList.Rows[j]["id"].ToString());
}
}
}
//跳转至待办任务页面
string url = targetUrl("admin%2fMissionList.aspx");
WX2HK.ReturnInfo.pushMessage(sb.ToString(), MessageName, url, "有您的审批信息，请及时查阅。", "");
}
}
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 btn_delete_Click(object sender, EventArgs e)
{
int[] selections = Grid1.SelectedRowIndexArray;
string sqlCmd = "";
StringBuilder sb_Order = new StringBuilder();
for (int i = 0; i < selections.Length; i++)
{
sqlCmd = "select count(*) from PLM_Serials_BindBarCode where tradeno='" + Grid1.DataKeys[selections[i]][0].ToString() + "'";
int bindCount = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
if (bindCount > 0)
{
Alert.ShowInTop(string.Format("第{0}行存在已上架数据，不可直接删除！", selections[i] + 1));
return;
}
else
{
sqlCmd = "delete from PLM_Product_OnLine where id='" + Grid1.DataKeys[selections[i]][0].ToString() + "'";
SqlSel.ExeSql(sqlCmd);
}
}
Alert.Show("已删除！");
}
protected void btn_publish_Click(object sender, EventArgs e)
{
try
{
string context = txb_title.Text;
string sqlCmd = "insert into OA_Announcement (AnncTitle,AnncContext,AnncAuthor,CreateTime,isDeleted) ";
sqlCmd += "values ('" + txb_title.Text + "','" + HtmlEditor1.Text + "','" + GetUser() + "','" + DateTime.Now + "','0')";
int execCount = SqlSel.ExeSql(sqlCmd);
if (execCount == 1)
{
sqlCmd = "select max(id) from OA_Announcement";
int anncId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
//插入附件
InsertFiles(anncId.ToString());
//微信推送
if (isPushWX.Checked)
{
DataTable wxUserDt = selectUser.getDeptUserList(System.Configuration.ConfigurationManager.AppSettings["CorpDeptId"]);//得到部门中的所有人员信息
System.Text.StringBuilder toUsers = new System.Text.StringBuilder();
for (int i = 0; i < wxUserDt.Rows.Count; i++)
{
toUsers.AppendFormat("{0}|", wxUserDt.Rows[i]["userid"].ToString());
}
string url = targetUrl(string.Format("admin%2fAnnouncement_Detail.aspx?id={0}", anncId));
ReturnInfo.pushMessage(toUsers.ToString(), "公告信息", url, context, "");
}
Alert.Show("公告发布成功！");
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
return;
}
}
protected void btn_save_Click(object sender, EventArgs e)
{
string sqlCmd = "";
int useStatus = ckeckBox_enabled.Checked ? 1 : 0;
if (string.IsNullOrEmpty(recvId))
{
sqlCmd = "insert into OA_sys_flow (flowName,createTime,isUsed,flowDesc) values (";
sqlCmd += "'" + txb_flowName.Text + "','" + DateTime.Now + "','" + useStatus + "','" + txa_flowDesc.Text + "')";
SqlSel.ExeSql(sqlCmd);
//获取流程id
sqlCmd = "select max(id) from OA_sys_flow";
int flowId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
//插入关联表单
string[] formArray = cbl_relForm.SelectedValueArray;
foreach (string selectItem in formArray)
{
sqlCmd = "insert into OA_Sys_FlowRelForm ([flowId],[formDataName]) values ('" + flowId + "','" + selectItem + "')";
SqlSel.ExeSql(sqlCmd);
}
//维护关联岗位数据
sqlCmd = "delete from OA_Sys_FlowRelDuty where flowid='" + flowId + "'";
SqlSel.ExeSql(sqlCmd);
//插入关联表单
string[] dutyArray = cbl_relDuty.SelectedValueArray;
foreach (string selectItem in dutyArray)
{
sqlCmd = "insert into OA_Sys_FlowRelDuty ([flowId],[dutyId]) values ('" + flowId + "','" + selectItem + "')";
SqlSel.ExeSql(sqlCmd);
}
}
else
{
sqlCmd = "update OA_sys_flow set flowName='" + txb_flowName.Text + "',createTime='" + DateTime.Now + "',isUsed='" + useStatus + "',flowDesc='" + txa_flowDesc.Text + "' where id=" + recvId;
SqlSel.ExeSql(sqlCmd);
//删除现有关联表单数据
sqlCmd = "delete from OA_Sys_FlowRelForm where flowid='" + recvId + "'";
SqlSel.ExeSql(sqlCmd);
//插入关联表单
string[] formArray = cbl_relForm.SelectedValueArray;
foreach (string selectItem in formArray)
{
sqlCmd = "insert into OA_Sys_FlowRelForm ([flowId],[formDataName]) values ('" + recvId + "','" + selectItem + "')";
SqlSel.ExeSql(sqlCmd);
}
//维护关联岗位数据
sqlCmd = "delete from OA_Sys_FlowRelDuty where flowid='" + recvId + "'";
SqlSel.ExeSql(sqlCmd);
//插入关联表单
string[] dutyArray = cbl_relDuty.SelectedValueArray;
foreach (string selectItem in dutyArray)
{
sqlCmd = "insert into OA_Sys_FlowRelDuty ([flowId],[dutyId]) values ('" + recvId + "','" + selectItem + "')";
SqlSel.ExeSql(sqlCmd);
}
}
Alert.Show("保存成功！请关闭当前窗口。");
//PageContext.RegisterStartupScript(ActiveWindow.GetHideReference());
}
