//显示工时汇总
public string ShowTimeSum()
{
//取得登录系统用户信息
Model.manager model = GetAdminInfo();
BLL.manager bll = new BLL.manager();
BLL.job_order bll1 = new BLL.job_order();
Model.job_order model1 = bll1.GetModel(int.Parse(this.id));
StringBuilder strReturn = new StringBuilder();
string strWhere = "job_order_id='" + model1.job_order_id + "'";
BLL.working_hour bll2 = new BLL.working_hour();
DataSet ds = bll2.GetDeptTimeSum(strWhere);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
strReturn.Append("<tr>");
strReturn.Append("<td></td>");
strReturn.Append("<td></td>");
strReturn.Append("<td></td>");
strReturn.Append("<td style=\"font-weight:bold;color:red\">共计 " + dr["count"] + " 条</td>");
strReturn.Append("<td style=\"font-weight:bold;color:red\">合计：</td>");
strReturn.Append("<td style=\"font-weight:bold;color:red\">" + dr["sum_working"] + "</td>");
strReturn.Append("<td style=\"font-weight:bold;color:red\">" + dr["sum_journey"] + "</td>");
strReturn.Append("<td style=\"font-weight:bold;color:red\">" + dr["sum_overtime"] + "</td>");
strReturn.Append("</tr>");
}
return(strReturn.ToString());
}
/// <summary>
/// 审核一条数据
/// </summary>
public bool Review(Model.job_order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gm_dt_job_order_base set ");
strSql.Append("job_order_status=@job_order_status,");
strSql.Append("job_order_advice=@job_order_advice");
strSql.Append(" where job_order_id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@job_order_status", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_advice", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.job_order_status;
parameters[1].Value = model.job_order_advice;
parameters[2].Value = model.job_order_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private bool DoEdit(string _review, int _id)
{
Model.manager manager = GetAdminInfo();
bool result = true;
Model.job_order model = new Model.job_order();
BLL.job_order bll = new BLL.job_order();
model.job_order_id = _id;
model.job_order_name = txtJobOrderName.Text.Trim();
model.job_order_type = ddlJobOrderType.SelectedIndex;
model.job_order_discripe = txtJobOrderDescript.Text.Trim();
model.contract_id = txtContractId.Text.Trim();
model.salesman_id = txtSalesman.Text.Trim();
model.job_order_begintime = DateTime.Parse(txtBeginDate.Text.Trim());
model.job_order_endtime = DateTime.Parse(txtEndDate.Text.Trim());
model.technical_respon_id = txtTechnicalResId.Text.Trim();
model.job_order_reviewer_id = txtReviewerId.Text.Trim();
model.job_order_status = _review;
model.job_order_create_time = DateTime.Now;
model.job_order_creator_id = manager.user_name;
model.job_order_advice = txtReviewAdvice.Text.Trim();
if (!bll.Update(model))
{
result = false;
}
return(result);
}
private bool DoEdit(int _id)
{
Model.manager manager = GetAdminInfo();
bool result = true;
Model.job_order model = new Model.job_order();
BLL.job_order bll = new BLL.job_order();
model.job_order_id = _id;
model.job_order_name = txtJobOrderName.Text.Trim();
model.job_order_type = ddlJobOrderType.SelectedIndex;
model.job_order_discripe = txtJobOrderDescript.Text.Trim();
model.contract_id = txtContractId.Text.Trim();
model.salesman_id = hidSalesman.Value.Trim();
model.job_order_begintime = DateTime.Parse(txtBeginDate.Text.Trim());
model.job_order_endtime = DateTime.Parse(txtEndDate.Text.Trim());
model.technical_respon_id = hidTechnicalResId.Value.Trim();
model.job_order_reviewer_id = hidReviewerId.Value.Trim();
model.job_order_status = "未审核";
//model.job_order_create_time = DateTime.Now;
model.job_order_creator_id = manager.user_name;
//model.job_order_relevant = hidRelevant.Value.Trim();
model.customer_id = int.Parse(hidCustomer.Value.Trim());
model.job_order_advice = "";
string strRelevant = hidRelevant.Value.Trim();
if (!string.IsNullOrEmpty(strRelevant))
{
try
{
string[] relevantArr = strRelevant.Split(';');
List <DTcms.Model.job_order_relevant> ls = new List <Model.job_order_relevant>();
for (int i = 0; i < relevantArr.Length; i++)
{
ls.Add(new DTcms.Model.job_order_relevant {
relevant_id = relevantArr[i]
});
}
model.job_order_relevant = ls;
}
catch
{
result = false;
}
}
if (!bll.Update(model))
{
result = false;
}
return(result);
}
//隐藏“填写工时”按钮
public bool HideLinkOrNot()
{
BLL.job_order bll1 = new BLL.job_order();
Model.job_order model1 = bll1.GetModel(this.id);
if (DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")) > DateTime.Parse(model1.job_order_endtime.ToString("yyyy-MM-dd")))
{
return(false);
}
else
{
return(true);
}
}
private bool DoEdit(string _review, int _id)
{
Model.manager manager = GetAdminInfo();
bool result = true;
Model.job_order model = new Model.job_order();
BLL.job_order bll = new BLL.job_order();
model.job_order_id = _id;
model.job_order_status = _review;
model.job_order_advice = txtReviewAdvice.Text.Trim();
if (!bll.Review(model))
{
result = false;
}
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.job_order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gm_dt_job_order_base(");
strSql.Append("job_order_name,job_order_type,job_order_discripe,contract_id,salesman_id,job_order_begintime,job_order_endtime,technical_respon_id,job_order_reviewer_id,job_order_create_time,job_order_status,job_order_advice,job_order_creator_id,customer_id)");
strSql.Append(" values (");
strSql.Append("@job_order_name,@job_order_type,@job_order_discripe,@contract_id,@salesman_id,@job_order_begintime,@job_order_endtime,@technical_respon_id,@job_order_reviewer_id,@job_order_create_time,@job_order_status,@job_order_advice,@job_order_creator_id,@customer_id)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
//new SqlParameter("@job_order_id", SqlDbType.Int,4),
new SqlParameter("@job_order_name", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_type", SqlDbType.Int, 4),
new SqlParameter("@job_order_discripe", SqlDbType.NVarChar, 50),
new SqlParameter("@contract_id", SqlDbType.NVarChar, 50),
new SqlParameter("@salesman_id", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_begintime", SqlDbType.DateTime),
new SqlParameter("@job_order_endtime", SqlDbType.DateTime),
new SqlParameter("@technical_respon_id", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_reviewer_id", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_create_time", SqlDbType.DateTime),
new SqlParameter("@job_order_status", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_advice", SqlDbType.NVarChar, 100),
new SqlParameter("@job_order_creator_id", SqlDbType.NVarChar, 50),
new SqlParameter("@customer_id", SqlDbType.Int, 4),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
//parameters[0].Value = model.job_order_id;
parameters[0].Value = model.job_order_name;
parameters[1].Value = model.job_order_type;
parameters[2].Value = model.job_order_discripe;
parameters[3].Value = model.contract_id;
parameters[4].Value = model.salesman_id;
parameters[5].Value = model.job_order_begintime;
parameters[6].Value = model.job_order_endtime;
parameters[7].Value = model.technical_respon_id;
parameters[8].Value = model.job_order_reviewer_id;
parameters[9].Value = model.job_order_create_time;
parameters[10].Value = model.job_order_status;
parameters[11].Value = model.job_order_advice;
parameters[12].Value = model.job_order_creator_id;
parameters[13].Value = model.customer_id;
parameters[14].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
//工单干系人
if (model.job_order_relevant != null)
{
StringBuilder strSql2;
foreach (Model.job_order_relevant models in model.job_order_relevant)
{
strSql2 = new StringBuilder();
strSql2.Append("insert into gm_dt_job_order_relevant(");
strSql2.Append("job_order_id,relevant_id)");
strSql2.Append(" values (");
strSql2.Append("@job_order_id,@relevant_id)");
SqlParameter[] parameters2 =
{
new SqlParameter("@job_order_id", SqlDbType.Int, 4),
new SqlParameter("@relevant_id", SqlDbType.NVarChar, 50)
};
parameters2[0].Direction = ParameterDirection.InputOutput;
parameters2[1].Value = models.relevant_id;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
}
}
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[14].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.job_order model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update gm_dt_job_order_base set ");
strSql.Append("job_order_type=@job_order_type,");
strSql.Append("job_order_discripe=@job_order_discripe,");
strSql.Append("contract_id=@contract_id,");
strSql.Append("salesman_id=@salesman_id,");
strSql.Append("job_order_begintime=@job_order_begintime,");
strSql.Append("job_order_endtime=@job_order_endtime,");
strSql.Append("technical_respon_id=@technical_respon_id,");
strSql.Append("job_order_status=@job_order_status,");
strSql.Append("job_order_reviewer_id=@job_order_reviewer_id,");
strSql.Append("customer_id=@customer_id,");
strSql.Append("job_order_advice=@job_order_advice");
strSql.Append(" where job_order_id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@job_order_type", SqlDbType.Int, 4),
new SqlParameter("@job_order_discripe", SqlDbType.NVarChar, 50),
new SqlParameter("@contract_id", SqlDbType.NVarChar, 50),
new SqlParameter("@salesman_id", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_begintime", SqlDbType.DateTime),
new SqlParameter("@job_order_endtime", SqlDbType.DateTime),
new SqlParameter("@technical_respon_id", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_status", SqlDbType.NVarChar, 50),
new SqlParameter("@job_order_reviewer_id", SqlDbType.NVarChar, 50),
new SqlParameter("@customer_id", SqlDbType.Int, 4),
new SqlParameter("@job_order_advice", SqlDbType.NVarChar, 100),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.job_order_type;
parameters[1].Value = model.job_order_discripe;
parameters[2].Value = model.contract_id;
parameters[3].Value = model.salesman_id;
parameters[4].Value = model.job_order_begintime;
parameters[5].Value = model.job_order_endtime;
parameters[6].Value = model.technical_respon_id;
parameters[7].Value = model.job_order_status;
parameters[8].Value = model.job_order_reviewer_id;
parameters[9].Value = model.customer_id;
parameters[10].Value = model.job_order_advice;
parameters[11].Value = model.job_order_id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//先删除原工单干系人数据
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from gm_dt_job_order_relevant ");
strSql2.Append(" where job_order_id=@id");
SqlParameter[] parameters2 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters2[0].Value = model.job_order_id;
DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
//先添加新工单干系人数据
if (model.job_order_relevant != null)
{
StringBuilder strSql3;
foreach (Model.job_order_relevant models in model.job_order_relevant)
{
strSql3 = new StringBuilder();
strSql3.Append("insert into gm_dt_job_order_relevant(");
strSql3.Append("job_order_id,relevant_id)");
strSql3.Append(" values (");
strSql3.Append("@job_order_id,@relevant_id)");
SqlParameter[] parameters3 =
{
new SqlParameter("@job_order_id", SqlDbType.Int, 4),
new SqlParameter("@relevant_id", SqlDbType.NVarChar, 50)
};
parameters3[0].Value = model.job_order_id;
parameters3[1].Value = models.relevant_id;
DbHelperSQL.ExecuteSql(conn, trans, strSql3.ToString(), parameters3);
}
}
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
private void ShowInfo(string _action, int _id)
{
BLL.job_order bll = new BLL.job_order();
Model.job_order model = bll.GetModel(_id);
BLL.manager tmpmanager = new BLL.manager();
BLL.customer customer = new BLL.customer();
txtJobOrderName.Text = model.job_order_name;
ddlJobOrderType.SelectedIndex = model.job_order_type;
txtJobOrderDescript.Text = model.job_order_discripe;
txtContractId.Text = model.contract_id;
txtSalesman.Text = tmpmanager.GetRealName(model.salesman_id);
txtBeginDate.Text = model.job_order_begintime.ToString();
txtEndDate.Text = model.job_order_endtime.ToString();;
txtTechnicalResId.Text = tmpmanager.GetRealName(model.technical_respon_id);
txtReviewerId.Text = tmpmanager.GetRealName(model.job_order_reviewer_id);
txtCreateTime.Text = model.job_order_create_time.ToString();
txtCreator.Text = tmpmanager.GetRealName(model.job_order_creator_id);
txtReviewAdvice.Text = model.job_order_advice;
txtStatus.Text = model.job_order_status;
txtCustomer.Text = customer.GetName(model.customer_id);
string strRelevantIdList = string.Empty;
string strRelevantNameList = string.Empty;
if (!object.Equals(model.job_order_relevant, null))
{
for (int i = 0; i < model.job_order_relevant.Count; i++)
{
if (strRelevantIdList.Equals(string.Empty))
{
strRelevantIdList = model.job_order_relevant[i].relevant_id;
strRelevantNameList = tmpmanager.GetRealName(model.job_order_relevant[i].relevant_id);
}
else
{
strRelevantIdList = strRelevantIdList + ";" + model.job_order_relevant[i].relevant_id;
strRelevantNameList = strRelevantNameList + ";" + tmpmanager.GetRealName(model.job_order_relevant[i].relevant_id);
}
}
}
//hidRelevant.Value = strRelevantIdList;
txtRelevant.Text = strRelevantNameList;
txtJobOrderName.Enabled = false;
ddlJobOrderType.Enabled = false;
txtJobOrderDescript.Enabled = false;
txtContractId.Enabled = false;
txtSalesman.Enabled = false;
txtBeginDate.Enabled = false;
txtEndDate.Enabled = false;
txtTechnicalResId.Enabled = false;
txtReviewerId.Enabled = false;
txtCreateTime.Enabled = false;
txtCreator.Enabled = false;
txtRelevant.Enabled = false;
//txtReviewAdvice.Enabled = false;
txtStatus.Enabled = false;
txtRelevant.Enabled = false;
txtCustomer.Enabled = false;
if (txtStatus.Text != "未审核")
{
txtReviewAdvice.Enabled = false;
rblReviewOrReject.Enabled = false;
btnSubmit.Visible = false;
}
////工时列表绑定
//BLL.working_hour working_hour = new BLL.working_hour();
//rptList.DataSource = working_hour.GetJobOrderWorkingHourList(model.job_order_id);
//rptList.DataBind();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.job_order model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.job_order model)
{
return(dal.Add(model));
}
/// <summary>
/// 审核一条数据
/// </summary>
public bool Review(Model.job_order model)
{
return(dal.Review(model));
}
