public object Post(long timestamp, string sign, [FromBody] UserScheme userRes)
{
if (ExternalResponse.signEncode(timestamp, sign))
{
return(ExternalResponse.ErrRequest(501, "sign的值错误"));
}
using (var db = new SunnyTeachEntities())
{
try
{
List <long> userids = new List <long>();
foreach (userparm up in userRes.users)
{
userids.Add(up.userid);
}
List <Tb_UserScheme> lUserScheme = db.Tb_UserScheme.Where(w => userids.Contains(w.UserID)).ToList();
foreach (var item in lUserScheme)
{
item.OptType = 1;
}
if (db.SaveChanges() != 0)
{
return(ExternalResponse.ExRequest3());
}
else
{
return(ExternalResponse.ErrRequest(504, "删除用户失败！"));
}
}
catch (Exception e)
{
return(ExternalResponse.ErrRequest(500, "服务器错误:" + e.Message));
}
}
}
public List <UserScheme> GetSchemeDetailsByID(int ID, string BPID)
{
UserScheme userScheme = new UserScheme();
List <UserScheme> lst = new List <UserScheme>();
DataSet ds = _scheme.GetSchemeDetailsByID(ID, BPID);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
userScheme = new UserScheme();
userScheme.FHNumber = dr["FHNumber"].ToString();
userScheme.SchemeNum = Convert.ToInt32(dr["SchemeNum"]);
userScheme.ProjectName = dr["ProjectName"].ToString();
userScheme.ProjectDescription = dr["ProjectDescription"].ToString();
userScheme.ProjectStartDate = Convert.ToDateTime(dr["ProjectStartDate"]);
userScheme.ProjectEndDate = Convert.ToDateTime(dr["ProjectEndDate"]);
userScheme.Sector = dr["SECID"].ToString();
userScheme.FilterName = dr["FilterName"].ToString();
userScheme.HarmonizeName = dr["HarmonizeName"].ToString();
userScheme.TemplateName = dr["TemplateName"].ToString();
lst.Add(userScheme);
}
}
return(lst);
}
public object Post(long timestamp, string sign, [FromBody] UserScheme userRes)
{
if (ExternalResponse.signEncode(timestamp, sign))
{
return(ExternalResponse.ErrRequest(501, "sign的值错误"));
}
using (var db = new SunnyTeachEntities())
{
Tb_Order tb_Order = db.Tb_Order.First(f => f.ID == userRes.ecordercode);
if (tb_Order == null)
{
return(ExternalResponse.ErrRequest(504, "未查询到相应订单!订单号:" + userRes.ecordercode));
}
try
{
Tb_UserScheme tb_UserScheme;
foreach (userparm up in userRes.users)
{
tb_UserScheme = db.Tb_UserScheme.Find(up.userid);
if (tb_UserScheme != null)
{
tb_UserScheme.OptType = up.opttype;
}
else
{
tb_UserScheme = new Tb_UserScheme();
tb_UserScheme.UserID = up.userid;
tb_UserScheme.ID = userRes.ecordercode;
tb_UserScheme.UserName = up.username;
tb_UserScheme.Useralias = up.useralias;
tb_UserScheme.Mobile = up.mobile;
tb_UserScheme.Email = up.email;
tb_UserScheme.BeginTime = up.begintime;
tb_UserScheme.EndTime = up.endtime;
tb_UserScheme.ApplyNo = userRes.ecordercode;
tb_UserScheme.EcorderCode = userRes.applyno;
tb_UserScheme.CustID = userRes.custid;
tb_UserScheme.ProductCode = userRes.productcode;
tb_UserScheme.OptType = up.opttype;
tb_UserScheme.IsDelete = 0;
tb_UserScheme.Paras = JsonHelper.JsonSerializer(up.paras);
tb_UserScheme.UserType = 0;// Convert.ToInt32(up.paras[0].value);
db.Tb_UserScheme.Add(tb_UserScheme);
}
}
if (db.SaveChanges() == 0)
{
return(ExternalResponse.ErrRequest(504, "添加用户或更新失败!"));
}
else
{
return(ExternalResponse.ExRequest3());
}
}
catch (Exception e)
{
return(ExternalResponse.ErrRequest(500, "服务器错误:" + e.Message));
}
}
}
public ActionResult CreateNewScheme(UserScheme userScheme)
{
int retvalue = -1;
retvalue = _scheme.CreateScheme(userScheme, "insert");
return(Json(retvalue, JsonRequestBehavior.AllowGet));
}
public ActionResult UpadateScheme(UserScheme userScheme)
{
int retvalue = -1;
retvalue = _scheme.CreateScheme(userScheme, "updatescheme");
return(Json(retvalue, JsonRequestBehavior.AllowGet));
}
public int CreateScheme(UserScheme userScheme, string op)
{
int retValue = -1;
try
{
con = ConnectionClass.getConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_InsertUpdateDeleteScheme";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = userScheme.ID;
cmd.Parameters.Add("@FHNumber", SqlDbType.NVarChar).Value = userScheme.FHNumber;
cmd.Parameters.Add("@SchemeNum", SqlDbType.Int).Value = userScheme.SchemeNum;
cmd.Parameters.Add("@SchemeName", SqlDbType.NVarChar).Value = userScheme.SchemeName;
cmd.Parameters.Add("@SchemeDescription", SqlDbType.NVarChar).Value = userScheme.SchemeDescription;
cmd.Parameters.Add("@SchemeType", SqlDbType.NVarChar).Value = userScheme.SchemeType;
cmd.Parameters.Add("@Client", SqlDbType.BigInt).Value = userScheme.Client;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = userScheme.Name;
cmd.Parameters.Add("@RegistrationType", SqlDbType.NVarChar).Value = userScheme.RegistrationType;
cmd.Parameters.Add("@ProjectType", SqlDbType.NVarChar).Value = userScheme.ProjectType;
cmd.Parameters.Add("@ProjectName", SqlDbType.NVarChar).Value = userScheme.ProjectName;
cmd.Parameters.Add("@ProjectDescription", SqlDbType.NVarChar).Value = userScheme.ProjectDescription;
cmd.Parameters.Add("@ProjectStartDate", SqlDbType.DateTime).Value = userScheme.ProjectStartDate;
cmd.Parameters.Add("@ProjectEndDate", SqlDbType.DateTime).Value = userScheme.ProjectEndDate;
cmd.Parameters.Add("@op", SqlDbType.NVarChar).Value = op;
cmd.Parameters.Add("@Suggestion", SqlDbType.NVarChar).Value = userScheme.Suggestion;
retValue = cmd.ExecuteNonQuery();
}
catch (SqlException sqlEx)
{
// Get orginal value from raise error by sql
retValue = -1;
// Write exception in log file
ConnectionClass.closeconnection(con);
DataLogger.Write("Scheme-CreateScheme", sqlEx.Message);
}
catch (Exception ex)
{
// Base exception
retValue = -1;
// Write exception in log file
ConnectionClass.closeconnection(con);
DataLogger.Write("Scheme-CreateScheme", ex.Message);
}
finally
{
ConnectionClass.closeconnection(con);
}
return(retValue);
}
public async Task <IHttpActionResult> CreateScheme([FromBody] UserScheme userScheme)
{
HttpResponseMessage response = new HttpResponseMessage();
try
{
var retvalue = await Task.Run(() => _schemeService.CreateScheme(userScheme));
return(Ok(retvalue));
}
catch (Exception ex)
{
response = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message);
return(ResponseMessage(response));
}
finally
{
}
}
public ActionResult ViewScheme(int ID)
{
string BPID = Session["BPID"].ToString();
SchemeDetails lstScheme = new SchemeDetails();
DataSet ds = new DataSet();
UserScheme userScheme = new UserScheme();
ds = _scheme.GetScheme(ID, "select");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
userScheme = new UserScheme();
userScheme.ID = Convert.ToInt32(dr["ID"]);
userScheme.SchemeNum = Convert.ToInt32(dr["SchemeNum"]);
userScheme.SchemeName = dr["SchemeName"].ToString();
userScheme.SchemeDescription = dr["SchemeDescription"].ToString();
userScheme.SchemeType = dr["SchemeType"].ToString();
userScheme.Client = Convert.ToInt64(dr["Client"]);
userScheme.Name = dr["Name"].ToString();
userScheme.RegistrationType = dr["RegistrationType"].ToString();
userScheme.ProjectType = dr["ProjectType"].ToString();
userScheme.ProjectName = dr["ProjectName"].ToString();
userScheme.ProjectDescription = dr["ProjectDescription"].ToString();
userScheme.SchemeComment = dr["SchemeComment"].ToString();
userScheme.ProjectStartDate = Convert.ToDateTime(dr["ProjectStartDate"]);
userScheme.ProjectEndDate = Convert.ToDateTime(dr["ProjectEndDate"]);
userScheme.IsActive = Convert.ToBoolean(dr["IsActive"]);
userScheme.IsArchive = Convert.ToBoolean(dr["IsArchive"]);
userScheme.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
userScheme.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
userScheme.Suggestion = dr["Suggestion"].ToString();
}
}
lstScheme.SchemeInfo = userScheme;
lstScheme.SchemeDetail = GetSchemeDetailsByID(ID, BPID);
return(PartialView("_ViewScheme", lstScheme));
}
public List <UserScheme> GetAllSchemeData(string BPID)
{
UserScheme userScheme = new UserScheme();
DataSet ds = new DataSet();
List <UserScheme> lst = new List <UserScheme>();
ds = _scheme.GetAllSchemeByBPID(BPID, "selectall");
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
userScheme = new UserScheme();
userScheme.ID = Convert.ToInt32(dr["ID"]);
userScheme.SchemeNum = Convert.ToInt32(dr["SchemeNum"]);
userScheme.SchemeName = dr["SchemeName"].ToString();
userScheme.SchemeDescription = dr["SchemeDescription"].ToString();
userScheme.SchemeType = dr["SchemeType"].ToString();
userScheme.Client = Convert.ToInt64(dr["Client"]);
userScheme.Name = dr["Name"].ToString();
userScheme.RegistrationType = dr["RegistrationType"].ToString();
userScheme.ProjectType = dr["ProjectType"].ToString();
userScheme.ProjectName = dr["ProjectName"].ToString();
userScheme.ProjectDescription = dr["ProjectDescription"].ToString();
userScheme.SchemeComment = dr["SchemeComment"].ToString();
userScheme.ProjectStartDate = Convert.ToDateTime(dr["ProjectStartDate"]);
userScheme.ProjectEndDate = Convert.ToDateTime(dr["ProjectEndDate"]);
userScheme.IsActive = Convert.ToBoolean(dr["IsActive"]);
userScheme.IsArchive = Convert.ToBoolean(dr["IsArchive"]);
userScheme.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);
userScheme.CreatedDate = Convert.ToDateTime(dr["CreatedDate"]);
userScheme.Suggestion = dr["Suggestion"].ToString();
lst.Add(userScheme);
}
}
return(lst);
}
public int CreateScheme(UserScheme userScheme)
{
return(_scheme.CreateScheme(userScheme, "insert"));
}
public int UpadateScheme(UserScheme userScheme)
{
return(_scheme.CreateScheme(userScheme, "updatescheme"));
}
