public string InsertRow(MucTieuCongViecModels clParam, string maNhanSu)
{
logger.Start("InsertRow");
string strResult = "";
try
{
Hashtable param = new Hashtable();
param["seqname"] = "seq_cv_kehoach";
string strid = sqlMap.ExecuteQueryForObject("Common.GetNextVal", param).ToString();
int iID = -1;
int.TryParse(strid, out iID);
if (iID == -1)
{
return(string.Empty);
}
//tao ma makehoach
param["makehoach"] = string.Format(Functiontring.ReturnStringFormatID("makehoach"),
maNhanSu,
DateTime.Now.Year,
DateTime.Now.Month,
iID.ToString("00000000"));
clParam.makehoach = param["makehoach"].ToString();
base.InsertData(clParam, "cv_kehoach");
strResult = param["makehoach"].ToString();
}
catch (Exception ex)
{
strResult = "-1";
logger.Error(ex.Message);
}
logger.End("InsertRow");
return(strResult);
}
public ActionResult Create(MucTieuCongViecModels muctieu)
{
if (!IsLogged())
{
return(BackToLogin());
}
muctieu.nguoitao = Session["userid"].ToString();
muctieu.daRICONSia = "0%";
muctieu.ketqua = "0%";
muctieu.tinhtrang = "1";//Chưa duyệt
muctieu.makehoachgoc = "0";
muctieu.nguoitao = Session["userid"].ToString();
if (GetPhongBanDonVi() != null)
{
muctieu.madonvi = GetPhongBanDonVi().madonvi;
}
MuctieucongviecServices services = new MuctieucongviecServices();
services.InsertRow(muctieu, Session["manhansu"].ToString());
return(RedirectToAction("Index", "Task"));
}
private StringBuilder PrepareDataJson(MucTieuCongViecModels model, int couter)
{
StringBuilder sbResult = new StringBuilder();
try
{
sbResult.Append("{");
sbResult.Append("\"col_class\":\"rows-box\",");
sbResult.Append("\"col_id\":\"" + "323" + "\",");
sbResult.Append("\"col_value\":[");
#region Data cell
//colum checkbox
string strHTML_Checkbox = string.Format("<input type='checkbox' onclick='Select(this);' class='chkCheck' codeid='{0}'/>", model.makehoach);
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col1\",");
sbResult.Append("\"col_id\":\"1\",");
sbResult.Append("\"col_value\":\"" + strHTML_Checkbox + "\"");
sbResult.Append("},");
//stt
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col2 stt\",");
//sbResult.Append("\"col_id\":\"2\",");
//sbResult.Append("\"col_value\":\"" + couter.ToString() + "\"");
//sbResult.Append("},");
//noi dung
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col3\",");
sbResult.Append("\"col_id\":\"3\",");
sbResult.Append("\"noidungmuctieu\":\"" + "23" + "\",");
sbResult.Append("\"col_value\":\"" + model.noidungmuctieu + "\"");
sbResult.Append("},");
//tỷ trọng (%)
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col4\",");
sbResult.Append("\"col_id\":\"4\",");
sbResult.Append("\"tytrong\":\"" + "23" + "\",");
sbResult.Append("\"col_value\":\"" + model.tytrong + "\"");
sbResult.Append("},");
//chỉ tieu năm
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col5\",");
sbResult.Append("\"col_id\":\"5\",");
sbResult.Append("\"chitieunam\":\"" + "323" + "\",");
sbResult.Append("\"col_value\":\"" + model.chitieunam + "\"");
sbResult.Append("},");
//ngay bat dau
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col6\",");
sbResult.Append("\"ngaybatdau\":\"8\",");
sbResult.Append("\"col_value\":\"" + model.ngaybatdau + "\"");
sbResult.Append("},");
//ngay ket thuc
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col6\",");
sbResult.Append("\"ngayketthuc\":\"8\",");
sbResult.Append("\"col_value\":\"" + model.ngayketthuc + "\"");
sbResult.Append("},");
////Tự danh gia ket qua
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col4\",");
sbResult.Append("\"col_id\":\"6\",");
sbResult.Append("\"nguoithuchien\":\"" + "23" + "\",");
sbResult.Append("\"col_value\":\"" + model.daRICONSia + "\"");
sbResult.Append("}");
////Xếp đánh giá kết quả
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col4\",");
sbResult.Append("\"col_id\":\"6\",");
sbResult.Append("\"nguoithuchien\":\"" + "23" + "\",");
sbResult.Append("\"col_value\":\"" + model.ketqua + "\"");
sbResult.Append("}");
//Người duyệt mục tiêu
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col7\",");
sbResult.Append("\"col_id\":\"6\",");
sbResult.Append("\"nguoithuchien\":\"" + "23" + "\",");
sbResult.Append("\"col_value\":\"" + model.nguoiduyetmuctieu + "\"");
sbResult.Append("}");
//Tình trang
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col8\",");
sbResult.Append("\"col_id\":\"6\",");
sbResult.Append("\"nguoithuchien\":\"" + "23" + "\",");
sbResult.Append("\"col_value\":\"" + model.tinhtrang + "\"");
sbResult.Append("}");
#endregion
sbResult.Append("]");
sbResult.Append("},");
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(sbResult);
}
