/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ProjectSharing model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update projectsharing set ");
strSql.Append("PROJECTID=@PROJECTID,");
strSql.Append("FINISHEDPERSON=@FINISHEDPERSON,");
strSql.Append("PROPORTION=@PROPORTION,");
strSql.Append("CREATEDATE=@CREATEDATE");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@PROJECTID", MySqlDbType.VarChar, 40),
new MySqlParameter("@FINISHEDPERSON", MySqlDbType.VarChar, 40),
new MySqlParameter("@PROPORTION", MySqlDbType.Double, 3),
new MySqlParameter("@CREATEDATE", MySqlDbType.DateTime),
new MySqlParameter("@ID", MySqlDbType.VarChar, 40)
};
parameters[0].Value = model.PROJECTID;
parameters[1].Value = model.FINISHEDPERSON;
parameters[2].Value = model.PROPORTION;
parameters[3].Value = model.CREATEDATE;
parameters[4].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ProjectSharing model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into projectsharing(");
strSql.Append("ID,PROJECTID,FINISHEDPERSON,PROPORTION,CREATEDATE)");
strSql.Append(" values (");
strSql.Append("@ID,@PROJECTID,@FINISHEDPERSON,@PROPORTION,@CREATEDATE)");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 40),
new MySqlParameter("@PROJECTID", MySqlDbType.VarChar, 40),
new MySqlParameter("@FINISHEDPERSON", MySqlDbType.VarChar, 40),
new MySqlParameter("@PROPORTION", MySqlDbType.Double, 3),
new MySqlParameter("@CREATEDATE", MySqlDbType.DateTime)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.PROJECTID;
parameters[2].Value = model.FINISHEDPERSON;
parameters[3].Value = model.PROPORTION;
parameters[4].Value = model.CREATEDATE;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ProjectSharing DataRowToModel(DataRow row)
{
ProjectSharing model = new ProjectSharing();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["PROJECTID"] != null)
{
model.PROJECTID = row["PROJECTID"].ToString();
}
if (row["FINISHEDPERSON"] != null)
{
model.FINISHEDPERSON = row["FINISHEDPERSON"].ToString();
}
//model.PROPORTION=row["PROPORTION"].ToString();
if (row["CREATEDATE"] != null && row["CREATEDATE"].ToString() != "")
{
model.CREATEDATE = DateTime.Parse(row["CREATEDATE"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ProjectSharing GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PROJECTID,FINISHEDPERSON,PROPORTION,CREATEDATE from projectsharing ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.VarChar, 40)
};
parameters[0].Value = ID;
ProjectSharing model = new ProjectSharing();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ProjectSharing model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ProjectSharing model)
{
return(dal.Add(model));
}
/// <summary>
/// 保存
/// </summary>
private void Save()
{
try
{
int rowsCount = gvData.Rows.Count;
GridViewRow gridRow;
TextBox textBox;
//System.Web.UI.HtmlControls.HtmlInputText textBox;
for (int i = 0; i < rowsCount; i++)
{
gridRow = gvData.Rows[i];
string id = gvData.DataKeys[i].Value.ToString();
textBox = (TextBox)gridRow.FindControl("txtProportion");
if (textBox != null)
{
LogHelper.WriteLine("txtId: " + textBox.Attributes["name"] + " TextBox.Text: " + textBox.Text);
string textValue = Request.Form["ctl00$ContentPlaceHolder1$gvData$ctl0" + (i + 2) + "$txtProportion"];
//double proportion = Convert.ToInt16(textBox.Text.Trim()) * 0.01;
double proportion = Convert.ToInt16(textValue) * 0.01;
ProjectSharing model = psBll.GetModel(id);
model.PROPORTION = proportion;
bool update = psBll.Update(model);
if (!update)
{
LogHelper.WriteLine("任务比例设置失败！");
Alert("设置失败！");
break;
}
}
//HtmlControls.HtmlInputText
//gridRow = gvData.Rows[i];
//string id = gvData.DataKeys[i].Value.ToString();
//textBox = (System.Web.UI.HtmlControls.HtmlInputText)gridRow.FindControl("txtProportion");
//if (textBox != null)
//{
// LogHelper.WriteLine("txtId: " + textBox.ID + " " + textBox.Value);
// //string textValue = Request.Form["ctl00$ContentPlaceHolder1$gvData$ctl0" + (i) + "$txtProportion"];
// double proportion = Convert.ToInt16(textBox.Value.Trim()) * 0.01;
// //double proportion = Convert.ToInt16(textValue) * 0.01;
// ProjectSharing model = psBll.GetModel(id);
// model.PROPORTION = proportion;
// bool update = psBll.Update(model);
// if (!update)
// {
// LogHelper.WriteLine("任务比例设置失败！");
// Alert("设置失败！");
// break;
// }
// else
// {
// RepeaterDataBind();
// Alert("设置成功！");
// }
//}
}
RepeaterDataBind();
Alert("设置成功！");
}
catch (Exception ex)
{
Alert("出错了！");
LogHelper.WriteLine(ex.Message + ex.StackTrace);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(ddlCanTransferEmp.SelectedValue))
{
ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('请选择需要转移到的员工！');", true);
return;
}
try
{
if (Convert.ToDecimal(txtProportion.Text.Trim()) > 100)
{
ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('比例不能超过100%！');", true);
return;
}
if (Convert.ToDecimal(txtAmount.Text.Trim()) > Convert.ToDecimal(hidAmount.Value))
{
ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('不能超过原始金额！');", true);
return;
}
}
catch (Exception ex0)
{
ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('数值不正确！');", true);
return;
}
// 声明变量
EmployeeAccountBLL eaBll = new EmployeeAccountBLL();
// 任务ID
string prjID = Request.QueryString["prjID"].ToString();
// 当前分部领导 empId
string parentEmployeeID = Convert.ToString(Request.QueryString["parentEmployeeID"]);
// 需要转移对象的 empId
string employeeID = ddlCanTransferEmp.SelectedValue;
// 移动目录
Employee empParent = empBll.GetModel(parentEmployeeID);
string parentEmpNo = empParent.EMPLOYEENO;
Employee empToTransfer = empBll.GetModel(employeeID);
string transferToEmpNo = empToTransfer.EMPLOYEENO;
FileCategoryBLL fcBll = new FileCategoryBLL();
int errCode = 0;
string returnFolderName = string.Empty;
string taskRootFolder = string.Empty;
string taskFolderWithoutEmpNo = string.Empty;
fcBll.GetFilePathByProjectId(prjID, string.Empty, string.Empty, false, out returnFolderName, out taskRootFolder, out taskFolderWithoutEmpNo, out errCode);
string sourceDirectory = string.Format(taskFolderWithoutEmpNo, parentEmpNo);
string destinctDirectory = string.Format(taskFolderWithoutEmpNo, transferToEmpNo);
try
{
Directory.Move(sourceDirectory, destinctDirectory);
}
catch (Exception ex)
{
LogHelper.WriteLine("|" + sourceDirectory + "|" + destinctDirectory);
LogHelper.WriteLine(ex.Message + ex.StackTrace);
ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('目录移动失败！');", true);
return;
}
// 更新部门领导账户，按照配置比例计算出金额后累加到分部领导账户
decimal proportion = 0;
ProjectProportion projectProportion = new ProjectProportionBLL().GetModelList(" projectId = '" + prjID + "'").FirstOrDefault();
if (projectProportion != null)
{
proportion = projectProportion.PROPORTION ?? 0m;
}
else
{
EmployeeProportion empProportion = new EmployeeProportionBLL().GetModelList(" AND employeeId = '" + parentEmployeeID + "'").FirstOrDefault();
proportion = empProportion.PROPORTION ?? 0m;
}
decimal amountToLeader = Convert.ToDecimal(Request.QueryString["amount"]);
EmployeeAccount empAcctParent = new EmployeeAccount();
empAcctParent = eaBll.GetModelList(" employeeId = '" + parentEmployeeID + "'").FirstOrDefault();
empAcctParent.AMOUNT += (amountToLeader * proportion);
empAcctParent.LASTUPDATEDATE = DateTime.Now;
eaBll.Update(empAcctParent);
// 添加一条交易记录
TransactionDetails transactionDetails = new TransactionDetails();
transactionDetails.ID = Guid.NewGuid().ToString();
transactionDetails.TRANSACTIONAMOUNT = amountToLeader * proportion;
transactionDetails.TRANSACTIONDESCRIPTION = "分部领导提成";
transactionDetails.TRANSACTIONPROPORTION = proportion;
transactionDetails.TRANSACTIONTYPE = 6;
transactionDetails.TRANSACTIONDATE = DateTime.Now;
transactionDetails.PLANDATE = DateTimeHelper.GetFirstDateOfCurrentMonth();
transactionDetails.EMPLOYEEID = parentEmployeeID;
transactionDetails.PROJECTID = prjID;
transactionDetails.ISDELETED = false;
tdBll.Add(transactionDetails);
//// 转移到的员工 先计入一条状态为已删除的数据，后续待任务完成时再调整：需要待任务完成后，再计入账户
transactionDetails = new TransactionDetails();
transactionDetails.ID = Guid.NewGuid().ToString();
transactionDetails.TRANSACTIONAMOUNT = Convert.ToDecimal(txtAmount.Text.Trim());
transactionDetails.TRANSACTIONDESCRIPTION = "项目提成（暂存）";
transactionDetails.TRANSACTIONTYPE = 7;
transactionDetails.TRANSACTIONDATE = DateTime.Now;
transactionDetails.PLANDATE = DateTimeHelper.GetFirstDateOfCurrentMonth();
transactionDetails.EMPLOYEEID = employeeID;
transactionDetails.PROJECTID = prjID;
transactionDetails.ISDELETED = true;
tdBll.Add(transactionDetails);
//EmployeeAccount empAcctTransferTo = new EmployeeAccount();
//empAcctTransferTo = eaBll.GetModelList(" employeeID = '" + employeeID + "'").FirstOrDefault();
//empAcctTransferTo.AMOUNT += Convert.ToDecimal(txtAmount.Text.Trim());
//empAcctTransferTo.LASTUPDATEDATE = DateTime.Now;
//eaBll.Update(empAcctTransferTo);
// 更新任务完成人
ProjectSharing ps = new ProjectSharing();
ps = psBll.GetModelList(" projectId = '" + prjID + "' AND FInishedperson = '" + parentEmployeeID + "'").FirstOrDefault();
ps.FINISHEDPERSON = employeeID;
if (psBll.Update(ps))
{
ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('转移成功！');window.top.location.href='/employeeHome.aspx';", true);
return;
}
ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(), "alert('更新完成人失败！');window.top.location.href='/employeeHome.aspx';", true);
return;
}
