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); }