protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnReset.OnClientClick = SimpleForm1.GetResetReference();
}
}
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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadData();
btnReset.OnClientClick = SimpleForm1.GetResetReference();
JsObjectBuilder joBuilder = new JsObjectBuilder();
joBuilder.AddProperty("id", "grid_newtab_material_addnew");
joBuilder.AddProperty("title", "新增材料");
joBuilder.AddProperty("iframeUrl", "getNewWindowUrl()", true);
joBuilder.AddProperty("refreshWhenExist", true);
joBuilder.AddProperty("iconFont", "plus");
btnNew.OnClientClick = String.Format("parent.addTab({0});", joBuilder);
}
}
//
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
//限当月提交
//int curMonth = DateTime.Now.Month;
//int subMonth = Convert.ToDateTime(DatePicker1.Text).Month;
//if (subMonth != curMonth)
//{
// Alert.ShowInTop("请假申请仅限当月提交");
// return;
//}
//补充说明不可超出数据库字段长度限制
if (TextArea_desc.Text.Length > 500)
{
Alert.ShowInTop("补充说明字符超限！");
return;
}
string date1 = DatePicker1.Text + " " + TimePicker1.Text;
string date2 = DatePicker2.Text + " " + TimePicker2.Text;
decimal days, hours;
string localImg = "";
//请假天数
if (string.IsNullOrEmpty(numbbox_days.Text))
{
days = 0;
}
else
{
days = Convert.ToDecimal(numbbox_days.Text);
}
//请假时间
if (string.IsNullOrEmpty(numbbox_hours.Text))
{
hours = 0;
}
else
{
hours = Convert.ToDecimal(numbbox_hours.Text);
}
//将图片保存至本地服务器
if (!string.IsNullOrEmpty(hidden_field.Value))
{
string access_token = VerifyLegal.GetAccess_Token();
localImg = GetMultimedia(access_token, hidden_field.Value);
}
string sqlCmd = "insert into T_LeaveReq (Typ,ReqMan,ReqDte,LeaveReason,LeaveDt1,LeaveDt2,Stat,Days,Hours,AddFunc,wxImgServId,localImgUrl) values ";
sqlCmd += "('" + RadioButtonList_goal.SelectedValue + "','" + workNo + "','" + DateTime.Now + "','" + TextArea_desc.Text + "','" + date1 + "','" + date2 + "',0,";
sqlCmd += "'" + days + "','" + hours + "',3,'" + hidden_field.Value + "','" + localImg + "')";
if (SqlSel.ExeSql(sqlCmd) == 0)
{
Alert.ShowInTop(sqlCmd, "执行出错！");
return;
}
else
{
sqlCmd = "select max(Id) from T_LeaveReq where reqman='" + workNo + "'";
int mainId = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd));
sqlCmd = "insert into Rs_QjAndJb_Subdtl (yhbh,Typ,MainId) values ('" + workNo + "','2'," + mainId + ")";
SqlSel.ExeSql(sqlCmd);
//插入审批表
sqlCmd = "select parent_Gh from View_Rs_employeeinfo where Gh_id = '" + workNo + "'";
if (string.IsNullOrEmpty(SqlSel.GetSqlScale(sqlCmd).ToString()))
{
sqlCmd = "update T_LeaveReq set stat=-1 where id=" + mainId;
SqlSel.ExeSql(sqlCmd);
Alert.ShowInTop("您的直属上级没有设置，无法填写请假申请，请联系人事部门。");
return;
}
String spMan = SqlSel.GetSqlScale(sqlCmd).ToString();
sqlCmd = "insert into T_SpFollow (spTyp,tabId,WorkNo,Checked,Sort) values ('2'," + mainId + ",'" + spMan + "','0','1')";
SqlSel.ExeSql(sqlCmd);
//超过5天的请假多层审批
//if (days > 5)
//{
// sqlCmd = "select parent_Gh from View_Rs_employeeinfo where Gh_id = '" + spMan + "'";
// if (string.IsNullOrEmpty(SqlSel.GetSqlScale(sqlCmd).ToString()))
// {
// //无上上级领导直接跳过
// }
// else
// {
// String spMan2 = SqlSel.GetSqlScale(sqlCmd).ToString();
// sqlCmd = "insert into T_SpFollow (spTyp,tabId,WorkNo,Checked,Sort) values ('2'," + mainId + ",'" + spMan2 + "','0','2')";
// SqlSel.ExeSql(sqlCmd);
// }
//}
//向对象推送相关消息
sqlCmd = "select CellPhone from x_user where name='" + spMan + "'";
string targetNum = SqlSel.GetSqlScale(sqlCmd).ToString();
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%2fCheckOut%2fLeaveOut_leaderView.aspx?mainId={0}&response_type=code&scope=SCOPE&state=STATE#wechat_redirect", mainId);
WX2HK.ReturnInfo.messagePushByNum(targetNum + ";", "请假单", url, string.Format("来自 {0}的请假申请", label_name.Text), "");
}
Alert.ShowInTop("提交成功！");
//提交按钮隐藏
btnSubmit.Hidden = true;
//表单重置
PageContext.RegisterStartupScript(SimpleForm1.GetResetReference());
//Image1.ImageUrl = null;
hidden_field.Value = null;
}
}
catch (Exception ex)
{
Alert.ShowInTop(ex.Message);
}
}