private void ShowInfo(string _action, int _id)
{
BLL.working_hour bll = new BLL.working_hour();
Model.working_hour model = bll.GetModel(_id);
BLL.manager tmpmanager = new BLL.manager();
if (_action == DTEnums.ActionEnum.Edit.ToString()) //修改
{
txtDate.Text = model.date.ToString("yyyy-MM-dd");
txtJobOrderName.Text = bll.GetJobOrderName(model.job_order_id);
hidJobOrderId.Value = model.job_order_id.ToString();
ddlProductType.SelectedIndex = model.product_type;
ddlServiceType.SelectedIndex = model.service_type;
txtWorkingContent.Text = model.working_content;
ddlStatus.SelectedIndex = model.status;
txtWorkingHours.Text = model.working_hours.ToString();
txtJourneyHours.Text = model.journey_hours.ToString();
txtOvertimeHours.Text = model.overtime_hours.ToString();
//绑定附件
rptAttach.DataSource = model.download_attachs;
rptAttach.DataBind();
}
else if (_action == DTEnums.ActionEnum.View.ToString()) //查看
{
txtDate.Text = model.date.ToString("yyyy-MM-dd");
txtJobOrderName.Text = bll.GetJobOrderName(model.job_order_id);
hidJobOrderId.Value = model.job_order_id.ToString();
ddlProductType.SelectedIndex = model.product_type;
ddlServiceType.SelectedIndex = model.service_type;
txtWorkingContent.Text = model.working_content;
ddlStatus.SelectedIndex = model.status;
txtWorkingHours.Text = model.working_hours.ToString();
txtJourneyHours.Text = model.journey_hours.ToString();
txtOvertimeHours.Text = model.overtime_hours.ToString();
txtDate.Enabled = false;
txtJobOrderName.Enabled = false;
ddlProductType.Enabled = false;
ddlServiceType.Enabled = false;
txtWorkingContent.Enabled = false;
ddlStatus.Enabled = false;
ddlProductType.Enabled = false;
txtJourneyHours.Enabled = false;
txtOvertimeHours.Enabled = false;
txtWorkingHours.Enabled = false;
btnSubmit.Visible = false;
//绑定附件
rptAttach.DataSource = model.download_attachs;
rptAttach.DataBind();
}
else
{
hidJobOrderId.Value = this.job_order_id;
txtJobOrderName.Text = this.job_order_name;
}
}
private bool DoEdit(int _id)
{
Model.manager manager = GetAdminInfo();
bool result = true;
Model.working_hour model = new Model.working_hour();
BLL.working_hour bll = new BLL.working_hour();
model.id = this.id;
model.date = DateTime.Parse(txtDate.Text.Trim());
model.job_order_id = Convert.ToInt32(hidJobOrderId.Value.Trim());
model.product_type = Convert.ToByte(ddlProductType.SelectedIndex);
model.service_type = Convert.ToByte(ddlServiceType.SelectedIndex);
model.working_content = txtWorkingContent.Text.Trim();
model.status = Convert.ToByte(ddlStatus.SelectedIndex);
model.working_hours = decimal.Parse(txtWorkingHours.Text.ToString());
model.journey_hours = decimal.Parse(txtJourneyHours.Text.ToString());
model.overtime_hours = decimal.Parse(txtOvertimeHours.Text.ToString());
//保存附件
if (model.download_attachs != null)
{
model.download_attachs.Clear();
}
string hidFileList = Request.Params["hidFileName"];
if (!string.IsNullOrEmpty(hidFileList))
{
string[] fileListArr = hidFileList.Split(',');
List <Model.download_attach> ls = new List <Model.download_attach>();
for (int i = 0; i < fileListArr.Length; i++)
{
string[] fileArr = fileListArr[i].Split('|');
if (fileArr.Length == 3)
{
int attach_id = int.Parse(fileArr[0]);
int fileSize = Utils.GetFileSize(fileArr[2]);
string fileExt = Utils.GetFileExt(fileArr[2]);
//删除旧文件
if (attach_id > 0)
{
new BLL.download_attach().DeleteFile(attach_id, fileArr[2]);
}
ls.Add(new Model.download_attach {
id = attach_id, article_id = _id, title = fileArr[1], file_path = fileArr[2], file_size = fileSize, file_ext = fileExt
});
}
}
model.download_attachs = ls;
}
if (!bll.Update(model))
{
result = false;
}
return(result);
}
private bool DoAdd()
{
bool result = true;
Model.working_hour model = new Model.working_hour();
BLL.working_hour bll = new BLL.working_hour();
model.user_name = manager.user_name;
model.date = DateTime.Parse(txtDate.Text.Trim());
//model.job_order_id = int.Parse(hidJobOrderId.Value.Trim());
model.job_order_id = Convert.ToInt32(hidJobOrderId.Value.Trim());
model.product_type = Convert.ToByte(ddlProductType.SelectedIndex);
model.service_type = Convert.ToByte(ddlServiceType.SelectedIndex);
model.working_content = txtWorkingContent.Text.Trim();
model.status = Convert.ToByte(ddlStatus.SelectedIndex);
model.working_hours = decimal.Parse(txtWorkingHours.Text.ToString());
model.journey_hours = decimal.Parse(txtJourneyHours.Text.ToString());
model.overtime_hours = decimal.Parse(txtOvertimeHours.Text.ToString());
model.create_time = DateTime.Now;
//保存附件
string hidFileList = Request.Params["hidFileName"];
if (!string.IsNullOrEmpty(hidFileList))
{
string[] fileListArr = hidFileList.Split(',');
List <Model.download_attach> ls = new List <Model.download_attach>();
for (int i = 0; i < fileListArr.Length; i++)
{
string[] fileArr = fileListArr[i].Split('|');
if (fileArr.Length == 3)
{
int fileSize = Utils.GetFileSize(fileArr[2]);
string fileExt = Utils.GetFileExt(fileArr[2]);
ls.Add(new Model.download_attach {
id = int.Parse(fileArr[0]), title = fileArr[1], file_path = fileArr[2], file_size = fileSize, file_ext = fileExt
});
}
}
model.download_attachs = ls;
}
if (bll.Add(model) < 1)
{
result = false;
}
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.working_hour model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.working_hour model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.working_hour model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gm_dt_working_hour(");
strSql.Append("user_name,date,job_order_id,product_type,service_type,working_content,working_hours,journey_hours,overtime_hours,status,create_time)");
strSql.Append(" values (");
strSql.Append("@user_name,@date,@job_order_id,@product_type,@service_type,@working_content,@working_hours,@journey_hours,@overtime_hours,@status,@create_time)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@user_name", SqlDbType.NVarChar, 50),
new SqlParameter("@date", SqlDbType.DateTime),
new SqlParameter("@job_order_id", SqlDbType.Int, 4),
new SqlParameter("@product_type", SqlDbType.TinyInt),
new SqlParameter("@service_type", SqlDbType.TinyInt),
new SqlParameter("@working_content", SqlDbType.NVarChar, 1000),
new SqlParameter("@working_hours", SqlDbType.Decimal),
new SqlParameter("@journey_hours", SqlDbType.Decimal),
new SqlParameter("@overtime_hours", SqlDbType.Decimal),
new SqlParameter("@status", SqlDbType.TinyInt),
new SqlParameter("@create_time", SqlDbType.DateTime),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.user_name;
parameters[1].Value = model.date;
parameters[2].Value = model.job_order_id;
parameters[3].Value = model.product_type;
parameters[4].Value = model.service_type;
parameters[5].Value = model.working_content;
parameters[6].Value = model.working_hours;
parameters[7].Value = model.journey_hours;
parameters[8].Value = model.overtime_hours;
parameters[9].Value = model.status;
parameters[10].Value = model.create_time;
parameters[11].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
//附件
if (model.download_attachs != null)
{
StringBuilder strSql4;
foreach (Model.download_attach models in model.download_attachs)
{
strSql4 = new StringBuilder();
strSql4.Append("insert into dt_download_attach(");
strSql4.Append("article_id,title,file_path,file_ext,file_size)");
strSql4.Append(" values (");
strSql4.Append("@article_id,@title,@file_path,@file_ext,@file_size)");
SqlParameter[] parameters4 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.NVarChar, 255),
new SqlParameter("@file_path", SqlDbType.NVarChar, 255),
new SqlParameter("@file_ext", SqlDbType.NVarChar, 100),
new SqlParameter("@file_size", SqlDbType.Int, 4)
};
parameters4[0].Direction = ParameterDirection.InputOutput;
parameters4[1].Value = models.title;
parameters4[2].Value = models.file_path;
parameters4[3].Value = models.file_ext;
parameters4[4].Value = models.file_size;
cmd = new CommandInfo(strSql4.ToString(), parameters4);
sqllist.Add(cmd);
}
}
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[11].Value);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.working_hour 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_working_hour set ");
strSql.Append("date=@date,");
strSql.Append("job_order_id=@job_order_id,");
strSql.Append("product_type=@product_type,");
strSql.Append("service_type=@service_type,");
strSql.Append("working_content=@working_content,");
strSql.Append("working_hours=@working_hours,");
strSql.Append("journey_hours=@journey_hours,");
strSql.Append("overtime_hours=@overtime_hours,");
strSql.Append("status=@status");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@date", SqlDbType.DateTime),
new SqlParameter("@job_order_id", SqlDbType.Int, 4),
new SqlParameter("@product_type", SqlDbType.TinyInt),
new SqlParameter("@service_type", SqlDbType.TinyInt),
new SqlParameter("@working_content", SqlDbType.NVarChar, 1000),
new SqlParameter("@working_hours", SqlDbType.Decimal),
new SqlParameter("@journey_hours", SqlDbType.Decimal),
new SqlParameter("@overtime_hours", SqlDbType.Decimal),
new SqlParameter("@status", SqlDbType.TinyInt),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.date;
parameters[1].Value = model.job_order_id;
parameters[2].Value = model.product_type;
parameters[3].Value = model.service_type;
parameters[4].Value = model.working_content;
parameters[5].Value = model.working_hours;
parameters[6].Value = model.journey_hours;
parameters[7].Value = model.overtime_hours;
parameters[8].Value = model.status;
parameters[9].Value = model.id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//删除已删除的附件
new download_attach().DeleteList(conn, trans, model.download_attachs, model.id);
// 添加/修改附件
if (model.download_attachs != null)
{
StringBuilder strSql2;
foreach (Model.download_attach models in model.download_attachs)
{
strSql2 = new StringBuilder();
if (models.id > 0)
{
strSql2.Append("update dt_download_attach set ");
strSql2.Append("article_id=@article_id,");
strSql2.Append("title=@title,");
strSql2.Append("file_path=@file_path,");
strSql2.Append("file_ext=@file_ext,");
strSql2.Append("file_size=@file_size");
strSql2.Append(" where id=@id");
SqlParameter[] parameters2 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.NVarChar, 255),
new SqlParameter("@file_path", SqlDbType.NVarChar, 255),
new SqlParameter("@file_ext", SqlDbType.NVarChar, 100),
new SqlParameter("@file_size", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters2[0].Value = models.article_id;
parameters2[1].Value = models.title;
parameters2[2].Value = models.file_path;
parameters2[3].Value = models.file_ext;
parameters2[4].Value = models.file_size;
parameters2[5].Value = models.id;
DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
}
else
{
strSql2.Append("insert into dt_download_attach(");
strSql2.Append("article_id,title,file_path,file_ext,file_size)");
strSql2.Append(" values (");
strSql2.Append("@article_id,@title,@file_path,@file_ext,@file_size)");
SqlParameter[] parameters2 =
{
new SqlParameter("@article_id", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.NVarChar, 255),
new SqlParameter("@file_path", SqlDbType.NVarChar, 255),
new SqlParameter("@file_ext", SqlDbType.NVarChar, 100),
new SqlParameter("@file_size", SqlDbType.Int, 4)
};
parameters2[0].Value = models.article_id;
parameters2[1].Value = models.title;
parameters2[2].Value = models.file_path;
parameters2[3].Value = models.file_ext;
parameters2[4].Value = models.file_size;
DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
}
}
}
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}