protected void btnSave_Click(object sender, EventArgs e)
{
CompanyScoreEntity companyScore = new CompanyScoreEntity();
companyScore.AdminId = logic.sysAdmin.AdminID;
companyScore.Reason = txtReason.Text;
int companyId = 0;
int.TryParse(hdCurrentCompanyId.Value,out companyId);
companyScore.CompanyId = companyId;
int score = 0;
int.TryParse(txtScore.Text, out score);
companyScore.Score = (ddlOperate.SelectedValue == "0" ? -score : score);
companyScore.Type = ddl_Type.SelectedValue;
int returnValue=logic.companyScore.insert(companyScore);
if (returnValue != 0)
{
Library.Script.ClientMsg("保存成功！");
txtReason.Text = "";
txtScore.Text = "";
ddlOperate.SelectedValue = "0";
rptBind();
}
else
{
Library.Script.ClientMsg("操作失败！原因可能是：企业得分等于零或者大于最高得分("+logic.webset.list().CompanyScore+")!");
return;
}
}
public static void update(CompanyScoreEntity companyScore)
{
DbHelper.ExecuteNonQuery("p_CompanyScore_update",
companyScore.Csid,
companyScore.CompanyId,
companyScore.Type,
companyScore.Score,
companyScore.Reason,
companyScore.AdminId,
companyScore.InputDt
);
}
public static CompanyScoreEntity getById(int csid)
{
DataRow dr = DbHelper.ExecuteDataRow("p_companyScore_getById", csid);
CompanyScoreEntity companyScore = new CompanyScoreEntity();
if (dr != null)
{
companyScore.Csid = int.Parse(dr["csid"].ToString());
companyScore.CompanyId = int.Parse(dr["companyId"].ToString());
companyScore.Type = dr["type"].ToString();
companyScore.Score = int.Parse(dr["score"].ToString());
companyScore.Reason = dr["reason"].ToString();
companyScore.AdminId = int.Parse(dr["adminId"].ToString());
companyScore.InputDt = DateTime.Parse(dr["inputDt"].ToString());
}
return companyScore;
}
public static int insert(CompanyScoreEntity companyScore)
{
int flag = 0;
object returnValue=DbHelper.ExecuteScalar("p_CompanyScore_insert",
companyScore.CompanyId,
companyScore.Type,
companyScore.Score,
companyScore.Reason,
companyScore.AdminId
);
if (returnValue!=null)
{
int.TryParse(returnValue.ToString(),out flag);
}
return flag;
}
