/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.CM.Model.UserPointDetail model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into UserPointDetail("); strSql.Append("UID,Point,Datetime,FlagType,Price,RDID)"); strSql.Append(" values ("); strSql.Append("@UID,@Point,@Datetime,@FlagType,@Price,@RDID)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID); db.AddInParameter(dbCommand, "Point", DbType.String, model.Point); db.AddInParameter(dbCommand, "Datetime", DbType.DateTime, model.Datetime); db.AddInParameter(dbCommand, "FlagType", DbType.Int32, model.FlagType); db.AddInParameter(dbCommand, "Price", DbType.Currency, model.Price); db.AddInParameter(dbCommand, "RDID", DbType.Int32, model.RDID); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.AUserInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into AUserInfo("); strSql.Append("Name,UserName,AUID,EntID,UID,CreateDate)"); strSql.Append(" values ("); strSql.Append("@Name,@UserName,@AUID,@EntID,@UID,@CreateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "Name", DbType.String, model.Name); db.AddInParameter(dbCommand, "UserName", DbType.String, model.UserName); db.AddInParameter(dbCommand, "AUID", DbType.Int32, model.AUID); db.AddInParameter(dbCommand, "EntID", DbType.Int32, model.EntID); db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.AnswerWrapper model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into AnswerWrapper("); strSql.Append("ComID,UId,Question_answer_1,Question_answer_2,Question_answer_3,Question_answer_4,Question_answer_5,Question_answer_6,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@Question_answer_1,@Question_answer_2,@Question_answer_3,@Question_answer_4,@Question_answer_5,@Question_answer_6,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Question_answer_1", DbType.String, model.Question_answer_1); db.AddInParameter(dbCommand, "Question_answer_2", DbType.String, model.Question_answer_2); db.AddInParameter(dbCommand, "Question_answer_3", DbType.String, model.Question_answer_3); db.AddInParameter(dbCommand, "Question_answer_4", DbType.String, model.Question_answer_4); db.AddInParameter(dbCommand, "Question_answer_5", DbType.String, model.Question_answer_5); db.AddInParameter(dbCommand, "Question_answer_6", DbType.String, model.Question_answer_6); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.RegisterUserInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into RegisterUserInfo("); strSql.Append("ProvinceId,CityId,DistrictId,Address,Phone,Addtime,Name)"); strSql.Append(" values ("); strSql.Append("@ProvinceId,@CityId,@DistrictId,@Address,@Phone,@Addtime,@Name)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ProvinceId", DbType.String, model.ProvinceId); db.AddInParameter(dbCommand, "CityId", DbType.String, model.CityId); db.AddInParameter(dbCommand, "DistrictId", DbType.AnsiString, model.DistrictId); db.AddInParameter(dbCommand, "Address", DbType.String, model.Address); db.AddInParameter(dbCommand, "Phone", DbType.AnsiString, model.Phone); db.AddInParameter(dbCommand, "Addtime", DbType.DateTime, model.Addtime); db.AddInParameter(dbCommand, "Name", DbType.String, model.Name); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.ProfInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ProfInfo("); strSql.Append("PTID,Name,UId,Age,ComAddr,Job,MajorSearch,Descri,Education,Photo,Status,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@PTID,@Name,@UId,@Age,@ComAddr,@Job,@MajorSearch,@Descri,@Education,@Photo,@Status,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "PTID", DbType.Int32, model.PTID); db.AddInParameter(dbCommand, "Name", DbType.String, model.Name); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Age", DbType.String, model.Age); db.AddInParameter(dbCommand, "ComAddr", DbType.String, model.ComAddr); db.AddInParameter(dbCommand, "Job", DbType.String, model.Job); db.AddInParameter(dbCommand, "MajorSearch", DbType.String, model.MajorSearch); db.AddInParameter(dbCommand, "Descri", DbType.String, model.Descri); db.AddInParameter(dbCommand, "Education", DbType.String, model.Education); db.AddInParameter(dbCommand, "Photo", DbType.String, model.Photo); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.CM.Model.CMColumn model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into CMColumn("); strSql.Append("ColName,ParentId,Level,Status,AddTime,SeoKey,SeoDes,ClickRate)"); strSql.Append(" values ("); strSql.Append("@ColName,@ParentId,@Level,@Status,@AddTime,@SeoKey,@SeoDes,@ClickRate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ColName", DbType.String, model.ColName); db.AddInParameter(dbCommand, "ParentId", DbType.Int32, model.ParentId); db.AddInParameter(dbCommand, "Level", DbType.Int32, model.Level); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime); db.AddInParameter(dbCommand, "SeoKey", DbType.String, model.SeoKey); db.AddInParameter(dbCommand, "SeoDes", DbType.String, model.SeoDes); db.AddInParameter(dbCommand, "ClickRate", DbType.Int32, model.ClickRate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.ProfOrg model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ProfOrg("); strSql.Append("Name,OrgAptitude,YYZZ,Addr,FR,Tel,Contact,Email,Descr,MajorSell,Logo,UId,Status,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@Name,@OrgAptitude,@YYZZ,@Addr,@FR,@Tel,@Contact,@Email,@Descr,@MajorSell,@Logo,@UId,@Status,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "Name", DbType.String, model.Name); db.AddInParameter(dbCommand, "OrgAptitude", DbType.String, model.OrgAptitude); db.AddInParameter(dbCommand, "YYZZ", DbType.String, model.YYZZ); db.AddInParameter(dbCommand, "Addr", DbType.String, model.Addr); db.AddInParameter(dbCommand, "FR", DbType.String, model.FR); db.AddInParameter(dbCommand, "Tel", DbType.String, model.Tel); db.AddInParameter(dbCommand, "Contact", DbType.String, model.Contact); db.AddInParameter(dbCommand, "Email", DbType.String, model.Email); db.AddInParameter(dbCommand, "Descr", DbType.String, model.Descr); db.AddInParameter(dbCommand, "MajorSell", DbType.String, model.MajorSell); db.AddInParameter(dbCommand, "Logo", DbType.String, model.Logo); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.OrgCustomerAddress model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrgCustomerAddress("); strSql.Append("CId,Province,City,County,Address,ReciveName,RecivePhone,IsDefault,AddTime,Status)"); strSql.Append(" values ("); strSql.Append("@CId,@Province,@City,@County,@Address,@ReciveName,@RecivePhone,@IsDefault,@AddTime,@Status)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "CId", DbType.Int32, model.CId); db.AddInParameter(dbCommand, "Province", DbType.AnsiString, model.Province); db.AddInParameter(dbCommand, "City", DbType.AnsiString, model.City); db.AddInParameter(dbCommand, "County", DbType.AnsiString, model.County); db.AddInParameter(dbCommand, "Address", DbType.String, model.Address); db.AddInParameter(dbCommand, "ReciveName", DbType.String, model.ReciveName); db.AddInParameter(dbCommand, "RecivePhone", DbType.AnsiString, model.RecivePhone); db.AddInParameter(dbCommand, "IsDefault", DbType.Byte, model.IsDefault); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.OrgCustomer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrgCustomer("); strSql.Append("OrgId,Name,Sex,Birthday,HomeAddress,SelfCard,AddTime,Status,UId,UserName,Password,Mobile)"); strSql.Append(" values ("); strSql.Append("@OrgId,@Name,@Sex,@Birthday,@HomeAddress,@SelfCard,@AddTime,@Status,@UId,@UserName,@Password,@Mobile)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "OrgId", DbType.Int64, model.OrgId); db.AddInParameter(dbCommand, "Name", DbType.String, model.Name); db.AddInParameter(dbCommand, "Sex", DbType.String, model.Sex); db.AddInParameter(dbCommand, "Birthday", DbType.DateTime, model.Birthday); db.AddInParameter(dbCommand, "HomeAddress", DbType.String, model.HomeAddress); db.AddInParameter(dbCommand, "SelfCard", DbType.AnsiString, model.SelfCard); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "UserName", DbType.AnsiString, model.UserName); db.AddInParameter(dbCommand, "Password", DbType.AnsiString, model.Password); db.AddInParameter(dbCommand, "Mobile", DbType.AnsiString, model.Mobile); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.FileList model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into FileList("); strSql.Append("ComID,UId,FileName,FPath,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@FileName,@FPath,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "FileName", DbType.String, model.FileName); db.AddInParameter(dbCommand, "FPath", DbType.String, model.FPath); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.ApplyList model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ApplyList("); strSql.Append("Name,Addr,Tel,Contact,Email,Descr,UId,AType,Status,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@Name,@Addr,@Tel,@Contact,@Email,@Descr,@UId,@AType,@Status,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "Name", DbType.String, model.Name); db.AddInParameter(dbCommand, "Addr", DbType.String, model.Addr); db.AddInParameter(dbCommand, "Tel", DbType.String, model.Tel); db.AddInParameter(dbCommand, "Contact", DbType.String, model.Contact); db.AddInParameter(dbCommand, "Email", DbType.String, model.Email); db.AddInParameter(dbCommand, "Descr", DbType.String, model.Descr); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "AType", DbType.Byte, model.AType); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Area.Model.LandInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LandInfo("); strSql.Append("AreaId,LName,LArea,LMemo,ParentId,langitude,dimension)"); strSql.Append(" values ("); strSql.Append("@AreaId,@LName,@LArea,@LMemo,@ParentId,@langitude,@dimension)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "AreaId", DbType.AnsiString, model.AreaId); db.AddInParameter(dbCommand, "LName", DbType.String, model.LName); db.AddInParameter(dbCommand, "LArea", DbType.String, model.LArea); db.AddInParameter(dbCommand, "LMemo", DbType.String, model.LMemo); db.AddInParameter(dbCommand, "ParentId", DbType.Int32, model.ParentId); db.AddInParameter(dbCommand, "langitude", DbType.AnsiString, model.langitude); db.AddInParameter(dbCommand, "dimension", DbType.AnsiString, model.dimension); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.DevelopmentService model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into DevelopmentService("); strSql.Append("ComID,UId,HF15,PS3,PS1,HF24,HF23,PC4,PC3,INN1,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@HF15,@PS3,@PS1,@HF24,@HF23,@PC4,@PC3,@INN1,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "HF15", DbType.String, model.HF15); db.AddInParameter(dbCommand, "PS3", DbType.String, model.PS3); db.AddInParameter(dbCommand, "PS1", DbType.String, model.PS1); db.AddInParameter(dbCommand, "HF24", DbType.String, model.HF24); db.AddInParameter(dbCommand, "HF23", DbType.String, model.HF23); db.AddInParameter(dbCommand, "PC4", DbType.String, model.PC4); db.AddInParameter(dbCommand, "PC3", DbType.String, model.PC3); db.AddInParameter(dbCommand, "INN1", DbType.String, model.INN1); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public long Add(ECommerce.Admin.Model.OrgOrganize model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into OrgOrganize("); strSql.Append("AreaId,OrgName,OrgAddress,OrgPhone,EnName,OrgFax,OrgType,OrgParentId,AddTime,Status,EndDate,SortNum)"); strSql.Append(" values ("); strSql.Append("@AreaId,@OrgName,@OrgAddress,@OrgPhone,@EnName,@OrgFax,@OrgType,@OrgParentId,@AddTime,@Status,@EndDate,@SortNum)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "AreaId", DbType.AnsiString, model.AreaId); db.AddInParameter(dbCommand, "OrgName", DbType.String, model.OrgName); db.AddInParameter(dbCommand, "OrgAddress", DbType.String, model.OrgAddress); db.AddInParameter(dbCommand, "OrgPhone", DbType.AnsiString, model.OrgPhone); db.AddInParameter(dbCommand, "EnName", DbType.String, model.EnName); db.AddInParameter(dbCommand, "OrgFax", DbType.AnsiString, model.OrgFax); db.AddInParameter(dbCommand, "OrgType", DbType.Byte, model.OrgType); db.AddInParameter(dbCommand, "OrgParentId", DbType.Int64, model.OrgParentId); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "EndDate", DbType.DateTime, model.EndDate); db.AddInParameter(dbCommand, "SortNum", DbType.Int32, model.SortNum); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.SYS_PageConfig model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into SYS_PageConfig("); strSql.Append("PC_Name,PC_Memo,PC_HrefUrl,PC_HaveChild,PC_ParentId,PC_State,PC_Icon)"); strSql.Append(" values ("); strSql.Append("@PC_Name,@PC_Memo,@PC_HrefUrl,@PC_HaveChild,@PC_ParentId,@PC_State,@PC_Icon)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "PC_Name", DbType.AnsiString, model.PC_Name); db.AddInParameter(dbCommand, "PC_Memo", DbType.AnsiString, model.PC_Memo); db.AddInParameter(dbCommand, "PC_HrefUrl", DbType.AnsiString, model.PC_HrefUrl); db.AddInParameter(dbCommand, "PC_HaveChild", DbType.Int32, model.PC_HaveChild); db.AddInParameter(dbCommand, "PC_ParentId", DbType.Int32, model.PC_ParentId); db.AddInParameter(dbCommand, "PC_State", DbType.Int32, model.PC_State); db.AddInParameter(dbCommand, "PC_Icon", DbType.String, model.PC_Icon); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.LoanInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LoanInfo("); strSql.Append("DID,LoID,Loaner,LoanDate,UId,OpName,LoanDescri,ReturnDescri,ReturnDate,Status,CreateDate)"); strSql.Append(" values ("); strSql.Append("@DID,@LoID,@Loaner,@LoanDate,@UId,@OpName,@LoanDescri,@ReturnDescri,@ReturnDate,@Status,@CreateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "DID", DbType.Int32, model.DID); db.AddInParameter(dbCommand, "LoID", DbType.Int32, model.LoID); db.AddInParameter(dbCommand, "Loaner", DbType.String, model.Loaner); db.AddInParameter(dbCommand, "LoanDate", DbType.DateTime, model.LoanDate); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "OpName", DbType.String, model.OpName); db.AddInParameter(dbCommand, "LoanDescri", DbType.String, model.LoanDescri); db.AddInParameter(dbCommand, "ReturnDescri", DbType.String, model.ReturnDescri); db.AddInParameter(dbCommand, "ReturnDate", DbType.DateTime, model.ReturnDate); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.OrgUsers model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into OrgUsers("); strSql.Append("EmplId,UserName,UserPwd,AddTime,Type,Status,LastLoginTime,UuserId,Upwd)"); strSql.Append(" values ("); strSql.Append("@EmplId,@UserName,@UserPwd,@AddTime,@Type,@Status,@LastLoginTime,@UuserId,@Upwd)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "EmplId", DbType.Int32, model.EmplId); db.AddInParameter(dbCommand, "UserName", DbType.AnsiString, model.UserName); db.AddInParameter(dbCommand, "UserPwd", DbType.AnsiString, model.UserPwd); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime); db.AddInParameter(dbCommand, "Type", DbType.Byte, model.Type); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "LastLoginTime", DbType.DateTime, model.LastLoginTime); db.AddInParameter(dbCommand, "UuserId", DbType.String, model.UuserId); db.AddInParameter(dbCommand, "Upwd", DbType.String, model.Upwd); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.BenchmarkCriteria model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into BenchmarkCriteria("); strSql.Append("ComID,UId,Country_Regions,EMP1,EMP2,TURN1,TURN2,INDUSTRY,List1,List2,SicCode,SelectedSicCodes,PROBE_SIC,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@Country_Regions,@EMP1,@EMP2,@TURN1,@TURN2,@INDUSTRY,@List1,@List2,@SicCode,@SelectedSicCodes,@PROBE_SIC,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Country_Regions", DbType.AnsiString, model.Country_Regions); db.AddInParameter(dbCommand, "EMP1", DbType.String, model.EMP1); db.AddInParameter(dbCommand, "EMP2", DbType.String, model.EMP2); db.AddInParameter(dbCommand, "TURN1", DbType.String, model.TURN1); db.AddInParameter(dbCommand, "TURN2", DbType.String, model.TURN2); db.AddInParameter(dbCommand, "INDUSTRY", DbType.AnsiString, model.INDUSTRY); db.AddInParameter(dbCommand, "List1", DbType.String, model.List1); db.AddInParameter(dbCommand, "List2", DbType.String, model.List2); db.AddInParameter(dbCommand, "SicCode", DbType.AnsiString, model.SicCode); db.AddInParameter(dbCommand, "SelectedSicCodes", DbType.AnsiString, model.SelectedSicCodes); db.AddInParameter(dbCommand, "PROBE_SIC", DbType.String, model.PROBE_SIC); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
public ActionResult Employee_Read([DataSourceRequest] DataSourceRequest request) { using (ECommerce db = new ECommerce()) { var result = EmployeeMangerDetails(); return(Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); } }
//getting user login details using private List <usps_UserLogInDetails_Result> AllCustomerInfo(string CustomerId, DateTime fromdate, DateTime todate) { using (ECommerce db = new ECommerce()) { //return db.usps_UserLogInDetails(CustomerID).ToList(); return(db.usps_UserLogInDetails(CustomerId, fromdate, todate).ToList()); } }
// GET: OrderHistory public ActionResult Index() { ProdutViewModel product = new ProdutViewModel(); using (ECommerce context = new ECommerce()) { product.ShoppingCart = context.ShoppingCarts.ToList(); } return(View(product)); }
// GET: Home public ActionResult Index() { ECommerce oECommerce = new ECommerce(); if (Session["DataSession"] != null) { return(View(Session["DataSession"])); } return(Redirect(oECommerce.GetUrlAuthorization())); }
public ActionResult Customer_Read([DataSourceRequest] DataSourceRequest request) { using (ECommerce db = new ECommerce()) { //IQueryable<Customer> customers = db.Customers; //DataSourceResult result = customers.ToDataSourceResult(request); //return Json(result, JsonRequestBehavior.AllowGet); var result = UserDetails(); return(Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); } }
public ActionResult Checkout(List <Checkout> obj) { List <ShoppingCart> lstCart = new List <ShoppingCart>(); using (ECommerce product = new ECommerce()) { using (var transaction = product.Database.BeginTransaction()) { try { if (obj != null) { foreach (Checkout item in obj) { ShoppingCart cart = new ShoppingCart(); //DateTime localDate = DateTime.Now; cart.CartId = item.CartId; cart.ProductName = item.ProductName; cart.Quantity = item.Quantity; decimal total = (item.Quantity * Convert.ToDecimal(item.Productprice)); cart.TotalAmount = total; cart.OrderDate = DateTime.Now; product.ShoppingCarts.Add(cart); product.SaveChanges(); //lstCart.Add(cart); } Order order = new Order(); order.CustomerID = Convert.ToInt32(Session["CustomerID"]); order.OrderDate = DateTime.Now; product.Orders.Add(order); product.SaveChanges(); } } catch (Exception ex) { transaction.Rollback(); } transaction.Commit(); } } var urlBuilder = new UrlHelper(Request.RequestContext); var url = urlBuilder.Action("Welcome", "Customers"); return(Json(new { status = "success", redirectUrl = url })); //return RedirectToAction("Welcome", "Customers"); //return View("~/Views/Customers/Welcome.cshtml"); //return View("~/Views/ShoppingCart/Cart.cshtml"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.ComInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into ComInfo("); strSql.Append("ComID,UId,ComName,Add1,Add2,Add3,City,Area,PostCode,Country,Phone,Fax,ComDesc,Industry,SubIndustry,SicCode,Industry2,SubIndustry2,SicCode2,Probe_sic,Probe_sic2,Probe_sic3,Employees,Domestic_company,Title,ContactFirstName,contactSurname,JobTitle,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@ComName,@Add1,@Add2,@Add3,@City,@Area,@PostCode,@Country,@Phone,@Fax,@ComDesc,@Industry,@SubIndustry,@SicCode,@Industry2,@SubIndustry2,@SicCode2,@Probe_sic,@Probe_sic2,@Probe_sic3,@Employees,@Domestic_company,@Title,@ContactFirstName,@contactSurname,@JobTitle,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "ComName", DbType.String, model.ComName); db.AddInParameter(dbCommand, "Add1", DbType.String, model.Add1); db.AddInParameter(dbCommand, "Add2", DbType.String, model.Add2); db.AddInParameter(dbCommand, "Add3", DbType.String, model.Add3); db.AddInParameter(dbCommand, "City", DbType.String, model.City); db.AddInParameter(dbCommand, "Area", DbType.String, model.Area); db.AddInParameter(dbCommand, "PostCode", DbType.String, model.PostCode); db.AddInParameter(dbCommand, "Country", DbType.String, model.Country); db.AddInParameter(dbCommand, "Phone", DbType.String, model.Phone); db.AddInParameter(dbCommand, "Fax", DbType.String, model.Fax); db.AddInParameter(dbCommand, "ComDesc", DbType.String, model.ComDesc); db.AddInParameter(dbCommand, "Industry", DbType.String, model.Industry); db.AddInParameter(dbCommand, "SubIndustry", DbType.String, model.SubIndustry); db.AddInParameter(dbCommand, "SicCode", DbType.String, model.SicCode); db.AddInParameter(dbCommand, "Industry2", DbType.String, model.Industry2); db.AddInParameter(dbCommand, "SubIndustry2", DbType.String, model.SubIndustry2); db.AddInParameter(dbCommand, "SicCode2", DbType.String, model.SicCode2); db.AddInParameter(dbCommand, "Probe_sic", DbType.String, model.Probe_sic); db.AddInParameter(dbCommand, "Probe_sic2", DbType.String, model.Probe_sic2); db.AddInParameter(dbCommand, "Probe_sic3", DbType.String, model.Probe_sic3); db.AddInParameter(dbCommand, "Employees", DbType.String, model.Employees); db.AddInParameter(dbCommand, "Domestic_company", DbType.String, model.Domestic_company); db.AddInParameter(dbCommand, "Title", DbType.String, model.Title); db.AddInParameter(dbCommand, "ContactFirstName", DbType.String, model.ContactFirstName); db.AddInParameter(dbCommand, "contactSurname", DbType.String, model.contactSurname); db.AddInParameter(dbCommand, "JobTitle", DbType.String, model.JobTitle); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.Financel model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into Financel("); strSql.Append("ComID,UId,Fyear,HF1,HF2,HF28,GHF1,GHF2,GHF28,HF43,HF44,HF3,GHF3,HF40,GHF40,HF6,HF8,HF20,HF45,HF7,HF13,HF12,HF10,HF11,HF9,HF14,HF21,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@Fyear,@HF1,@HF2,@HF28,@GHF1,@GHF2,@GHF28,@HF43,@HF44,@HF3,@GHF3,@HF40,@GHF40,@HF6,@HF8,@HF20,@HF45,@HF7,@HF13,@HF12,@HF10,@HF11,@HF9,@HF14,@HF21,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Fyear", DbType.String, model.Fyear); db.AddInParameter(dbCommand, "HF1", DbType.String, model.HF1); db.AddInParameter(dbCommand, "HF2", DbType.String, model.HF2); db.AddInParameter(dbCommand, "HF28", DbType.String, model.HF28); db.AddInParameter(dbCommand, "GHF1", DbType.String, model.GHF1); db.AddInParameter(dbCommand, "GHF2", DbType.String, model.GHF2); db.AddInParameter(dbCommand, "GHF28", DbType.String, model.GHF28); db.AddInParameter(dbCommand, "HF43", DbType.String, model.HF43); db.AddInParameter(dbCommand, "HF44", DbType.String, model.HF44); db.AddInParameter(dbCommand, "HF3", DbType.String, model.HF3); db.AddInParameter(dbCommand, "GHF3", DbType.String, model.GHF3); db.AddInParameter(dbCommand, "HF40", DbType.String, model.HF40); db.AddInParameter(dbCommand, "GHF40", DbType.String, model.GHF40); db.AddInParameter(dbCommand, "HF6", DbType.String, model.HF6); db.AddInParameter(dbCommand, "HF8", DbType.String, model.HF8); db.AddInParameter(dbCommand, "HF20", DbType.String, model.HF20); db.AddInParameter(dbCommand, "HF45", DbType.String, model.HF45); db.AddInParameter(dbCommand, "HF7", DbType.String, model.HF7); db.AddInParameter(dbCommand, "HF13", DbType.String, model.HF13); db.AddInParameter(dbCommand, "HF12", DbType.String, model.HF12); db.AddInParameter(dbCommand, "HF10", DbType.String, model.HF10); db.AddInParameter(dbCommand, "HF11", DbType.String, model.HF11); db.AddInParameter(dbCommand, "HF9", DbType.String, model.HF9); db.AddInParameter(dbCommand, "HF14", DbType.String, model.HF14); db.AddInParameter(dbCommand, "HF21", DbType.String, model.HF21); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
// GET: Auth public ActionResult Index(string code) { ECommerce oECommerce = new ECommerce(); if (!string.IsNullOrEmpty(code)) { //Get Access Token string token = oECommerce.GetToken(code); var rrr = token.Split('-'); Session["DataSession"] = oECommerce.GetUser(rrr[4], token); //Get Data User } return(RedirectToAction("Index", "Home")); }
public ActionResult AddToCart(int productId) { ProdutViewModel objProductDetails = new ProdutViewModel(); if (objProductDetails != null) { using (ECommerce objEntity = new ECommerce()) { objProductDetails.ProductDetails = objEntity.ProductInfoes.Where(p => p.ProductID == productId).Include(p => p.ProductCategory).FirstOrDefault(); } return(View(objProductDetails)); } else { return(View("Details", "ProductInfoes")); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Admin.Model.WorkAnswer model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into WorkAnswer("); strSql.Append("ComID,UId,Question_answer_25,Question_answer_26,Question_answer_27,Question_answer_28,Question_answer_29,Question_answer_30,Question_answer_31,Question_answer_32,Question_answer_33,Question_answer_34,Question_answer_35,Question_answer_36,Question_answer_37,Question_answer_38,Question_answer_39,Question_answer_40,Question_answer_41,Question_answer_42,Question_answer_43,Question_answer_44,Question_answer_45,Question_answer_46,Question_answer_47,CreateDate,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@ComID,@UId,@Question_answer_25,@Question_answer_26,@Question_answer_27,@Question_answer_28,@Question_answer_29,@Question_answer_30,@Question_answer_31,@Question_answer_32,@Question_answer_33,@Question_answer_34,@Question_answer_35,@Question_answer_36,@Question_answer_37,@Question_answer_38,@Question_answer_39,@Question_answer_40,@Question_answer_41,@Question_answer_42,@Question_answer_43,@Question_answer_44,@Question_answer_45,@Question_answer_46,@Question_answer_47,@CreateDate,@UpdateDate)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ComID", DbType.String, model.ComID); db.AddInParameter(dbCommand, "UId", DbType.Int32, model.UId); db.AddInParameter(dbCommand, "Question_answer_25", DbType.String, model.Question_answer_25); db.AddInParameter(dbCommand, "Question_answer_26", DbType.String, model.Question_answer_26); db.AddInParameter(dbCommand, "Question_answer_27", DbType.String, model.Question_answer_27); db.AddInParameter(dbCommand, "Question_answer_28", DbType.String, model.Question_answer_28); db.AddInParameter(dbCommand, "Question_answer_29", DbType.String, model.Question_answer_29); db.AddInParameter(dbCommand, "Question_answer_30", DbType.String, model.Question_answer_30); db.AddInParameter(dbCommand, "Question_answer_31", DbType.String, model.Question_answer_31); db.AddInParameter(dbCommand, "Question_answer_32", DbType.String, model.Question_answer_32); db.AddInParameter(dbCommand, "Question_answer_33", DbType.String, model.Question_answer_33); db.AddInParameter(dbCommand, "Question_answer_34", DbType.String, model.Question_answer_34); db.AddInParameter(dbCommand, "Question_answer_35", DbType.String, model.Question_answer_35); db.AddInParameter(dbCommand, "Question_answer_36", DbType.String, model.Question_answer_36); db.AddInParameter(dbCommand, "Question_answer_37", DbType.String, model.Question_answer_37); db.AddInParameter(dbCommand, "Question_answer_38", DbType.String, model.Question_answer_38); db.AddInParameter(dbCommand, "Question_answer_39", DbType.String, model.Question_answer_39); db.AddInParameter(dbCommand, "Question_answer_40", DbType.String, model.Question_answer_40); db.AddInParameter(dbCommand, "Question_answer_41", DbType.String, model.Question_answer_41); db.AddInParameter(dbCommand, "Question_answer_42", DbType.String, model.Question_answer_42); db.AddInParameter(dbCommand, "Question_answer_43", DbType.String, model.Question_answer_43); db.AddInParameter(dbCommand, "Question_answer_44", DbType.String, model.Question_answer_44); db.AddInParameter(dbCommand, "Question_answer_45", DbType.String, model.Question_answer_45); db.AddInParameter(dbCommand, "Question_answer_46", DbType.String, model.Question_answer_46); db.AddInParameter(dbCommand, "Question_answer_47", DbType.String, model.Question_answer_47); db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "UpdateDate", DbType.DateTime, model.UpdateDate); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
public JsonResult Get_Employees(int?id) { var dataContext = new ECommerce(); var employees = from e in dataContext.Employees where (id.HasValue ? e.Manager == id : e.Manager == 0) select new { id = e.EmpID, Name = e.EmployeeName, hasChildren = (from q in dataContext.Employees where (q.Manager == e.EmpID) select q ) }; return(Json(employees, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ECommerce.CM.Model.CMArea model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMArea("); strSql.Append("AId,AreaId)"); strSql.Append(" values ("); strSql.Append("@AId,@AreaId)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "AId", DbType.Int32, model.AId); db.AddInParameter(dbCommand, "AreaId", DbType.AnsiString, model.AreaId); int result = db.ExecuteNonQuery(dbCommand); if (result > 0) { return true; } return false; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ECommerce.Admin.Model.SWCompany model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SWCompany("); strSql.Append("SWOrgId,COrgId)"); strSql.Append(" values ("); strSql.Append("@SWOrgId,@COrgId)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "SWOrgId", DbType.Int32, model.SWOrgId); db.AddInParameter(dbCommand, "COrgId", DbType.Int32, model.COrgId); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return false; } return true; }
// GET: Category public ActionResult Index(string id) { ECommerce oECommerce = new ECommerce(); if (!string.IsNullOrEmpty(id)) { var oQuery = oECommerce.GetCategory(id); if (oQuery.children_categories.Count == 0) { return(RedirectToAction("Search", "Item", new { id = id, type = "2" })); } return(View(oQuery)); } Model.Models.ECommerce.Products.Category oResult = new Model.Models.ECommerce.Products.Category(); oResult.children_categories = oECommerce.GetCategories(Model.Models.General.Enumerations.enumCountries.MCO.ToString()); return(View(oResult)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ECommerce.CM.Model.CMPro model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMPro("); strSql.Append("AId,PID)"); strSql.Append(" values ("); strSql.Append("@AId,@PID)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "AId", DbType.Int32, model.AId); db.AddInParameter(dbCommand, "PID", DbType.Int32, model.PID); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return false; } return true; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.Area.Model.LandAttribute model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into LandAttribute("); strSql.Append("LAName,Status)"); strSql.Append(" values ("); strSql.Append("@LAName,@Status)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "LAName", DbType.String, model.LAName); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ECommerce.Admin.Model.MessageUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MessageUser("); strSql.Append("MID,UID,Status)"); strSql.Append(" values ("); strSql.Append("@MID,@UID,@Status)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MID", DbType.Int32, model.MID); db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID); db.AddInParameter(dbCommand, "Status", DbType.Int16, model.Status); int result; object obj = db.ExecuteScalar(dbCommand); //if (!int.TryParse(obj.ToString(), out result)) //{ // return false; //} return true; }
static void Main(string[] args) { ECommerce eCommerce = new ECommerce( new Traffic { Amount = 1000, CPC = 0.02 }, new LandingPage { CTR = 1 }, new SalesPage { Cost = 1, Price = 10, CR = .01f }, new UpSell { Cost = 2, Price = 10, CR = .5f }); WriteLine(eCommerce); ReadLine(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.CM.Model.CMEmplColumn model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into CMEmplColumn("); strSql.Append("EmplId,ColId)"); strSql.Append(" values ("); strSql.Append("@EmplId,@ColId)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "EmplId", DbType.Int32, model.EmplId); db.AddInParameter(dbCommand, "ColId", DbType.Int32, model.ColId); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.CM.Model.CMArticle model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into CMArticle("); strSql.Append("ColId,ATId,Title,Description,Author,Source,Content,Hits,Status,IsTop,IsSplendid,PEmplId,CEmplId,AddTime,CheckTime,SeoTitle,SeoKeyword,SeoDes,AttType,OrgId,DisplayTime)"); strSql.Append(" values ("); strSql.Append("@ColId,@ATId,@Title,@Description,@Author,@Source,@Content,@Hits,@Status,@IsTop,@IsSplendid,@PEmplId,@CEmplId,@AddTime,@CheckTime,@SeoTitle,@SeoKeyword,@SeoDes,@AttType,@OrgId,@DisplayTime)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ColId", DbType.Int32, model.ColId); db.AddInParameter(dbCommand, "ATId", DbType.Int32, model.ATId); db.AddInParameter(dbCommand, "Title", DbType.String, model.Title); db.AddInParameter(dbCommand, "Description", DbType.String, model.Description); db.AddInParameter(dbCommand, "Author", DbType.String, model.Author); db.AddInParameter(dbCommand, "Source", DbType.String, model.Source); db.AddInParameter(dbCommand, "Content", DbType.String, model.Content); db.AddInParameter(dbCommand, "Hits", DbType.Int32, model.Hits); db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status); db.AddInParameter(dbCommand, "IsTop", DbType.Byte, model.IsTop); db.AddInParameter(dbCommand, "IsSplendid", DbType.Byte, model.IsSplendid); db.AddInParameter(dbCommand, "PEmplId", DbType.Int32, model.PEmplId); db.AddInParameter(dbCommand, "CEmplId", DbType.Int32, model.CEmplId); db.AddInParameter(dbCommand, "AddTime", DbType.DateTime, model.AddTime); db.AddInParameter(dbCommand, "CheckTime", DbType.DateTime, model.CheckTime); db.AddInParameter(dbCommand, "SeoTitle", DbType.String, model.SeoTitle); db.AddInParameter(dbCommand, "SeoKeyword", DbType.String, model.SeoKeyword); db.AddInParameter(dbCommand, "SeoDes", DbType.String, model.SeoDes); db.AddInParameter(dbCommand, "AttType", DbType.Byte, model.AttType); db.AddInParameter(dbCommand, "OrgId", DbType.Int64, model.OrgId); db.AddInParameter(dbCommand, "DisplayTime", DbType.Int32, model.DisplayTime); int result; object obj = db.ExecuteScalar(dbCommand); if(!int.TryParse(obj.ToString(),out result)) { return 0; } return result; }
public void Test_RegisterWithResolveExplicitValues() { Container container = new Container(); BillingProcessor billingProcessor = new BillingProcessor(PaymentType.CreditCard); container.Register <IBillingProcessor>(billingProcessor); container.Register <ICustomer, InternetCustomer>(); container.Register <INotifier, EmailNotifer>(); OnlineOrder onlineOrder = new OnlineOrder() { CustomerId = 12212, EmailAddress = "*****@*****.**", Price = 400, Product = "NewProduct" }; ECommerce commerce = container.Resolve <ECommerce>(); commerce.Process(onlineOrder); Assert.IsNotNull(commerce); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.CM.Model.CMArticleType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CMArticleType("); strSql.Append("ATName,DisplayCss,ColorValue)"); strSql.Append(" values ("); strSql.Append("@ATName,@DisplayCss,@ColorValue)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ATName", DbType.String, model.ATName); db.AddInParameter(dbCommand, "DisplayCss", DbType.AnsiString, model.DisplayCss); db.AddInParameter(dbCommand, "ColorValue", DbType.String, model.ColorValue); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return 0; } return result; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ECommerce.CM.Model.PointRule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PointRule("); strSql.Append("RName,RxValue,RyValue)"); strSql.Append(" values ("); strSql.Append("@RName,@RxValue,@RyValue)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "RName", DbType.String, model.RName); db.AddInParameter(dbCommand, "RxValue", DbType.String, model.RxValue); db.AddInParameter(dbCommand, "RyValue", DbType.String, model.RyValue); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return 0; } return result; }
public void Test_RegisterWithResolve() { Container container = new Container(); container.Register <IBillingProcessor, BillingProcessor>(); container.Register <ICustomer, InternetCustomer>(); container.Register <INotifier, EmailNotifer>(); OnlineOrder onlineOrder = new OnlineOrder() { CustomerId = 12212, EmailAddress = "*****@*****.**", Price = 400, Product = "NewProduct" }; ECommerce commerce = container.CreateInstance <ECommerce>(); commerce.Process(onlineOrder); Assert.IsNotNull(commerce); }
public ProductRepository(ECommerce context) : base(context) { }
public void GetItem() { ECommerce it = new ECommerce(); var result = it.GetItem("MCO448896604"); }
public void GetCategory() { ECommerce ep = new ECommerce(); var result = ep.GetCategory("MCO6934");//Accesorios para carro }
public void GetCategories() { ECommerce ec = new ECommerce(); var result = ec.GetCategories(Enumerations.enumCountries.MCO.ToString()); }
public List <DetallesECommerce> get_DetGuia_EC(string venta_id) { string sqlquery = "USP_REP_GUIA_ECOMMERCE"; ECommerce guia = null; List <DetallesECommerce> lista = null; DataTable dt = null; try { using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexionEcommerce)) { try { using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ven_id", venta_id); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { dt = new DataTable(); da.Fill(dt); lista = new List <DetallesECommerce>(); lista = (from DataRow dr in dt.Rows select new DetallesECommerce() { codigoProducto = dr["codigoProducto"].ToString(), nombreProducto = dr["nombreProducto"].ToString(), cantidad = Convert.ToInt32(dr["cantidad"]), precioUnitario = Convert.ToDecimal(dr["precioUnitario"]), descuento = Convert.ToDecimal(dr["descuento"]), total = Convert.ToDecimal(dr["total"]), talla = dr["talla"].ToString(), }).ToList(); guia = new ECommerce(); guia.idPedido = dt.Rows[0]["idPedido"].ToString(); guia.Referencia = dt.Rows[0]["Referencia"].ToString(); guia.fechaPedido = Convert.ToDateTime(dt.Rows[0]["fechaPedido"]); guia.tipoComprobante = dt.Rows[0]["tipoComprobante"].ToString(); guia.SerieDoc = dt.Rows[0]["SerieDoc"].ToString(); guia.GuiaNro = dt.Rows[0]["GuiaNro"].ToString(); guia.NroDoc = dt.Rows[0]["NroDoc"].ToString(); guia.codSeguimiento = dt.Rows[0]["codSeguimiento"].ToString(); guia.nom_courier = dt.Rows[0]["nom_courier"].ToString(); guia.estado = dt.Rows[0]["estado"].ToString(); guia.cliente = dt.Rows[0]["cliente"].ToString(); guia.direccionA = dt.Rows[0]["direccionA"].ToString(); guia.direccionB = dt.Rows[0]["direccionB"].ToString(); guia.direccionCliente = dt.Rows[0]["direccionCliente"].ToString(); guia.referenciaCliente = dt.Rows[0]["referenciaCliente"].ToString(); guia.TpDocCli = dt.Rows[0]["TpDocCli"].ToString(); guia.noDocCli = dt.Rows[0]["noDocCli"].ToString(); guia.nombreCliente = dt.Rows[0]["nombreCliente"].ToString(); guia.apePatCliente = dt.Rows[0]["apePatCliente"].ToString(); guia.apeMatCliente = dt.Rows[0]["apeMatCliente"].ToString(); guia.nombreCompletoCliente = dt.Rows[0]["nombreCompletoCliente"].ToString(); guia.cod_entid = dt.Rows[0]["cod_entid"].ToString(); guia.nombreEstado = dt.Rows[0]["nombreEstado"].ToString(); guia.detalles = lista; } } } catch (Exception ex) { } } } catch { } return(lista); }
public List <ECommerce> getGuia_EC(string venta_id) { string sqlquery = "USP_REP_GUIA_ECOMMERCE"; List <ECommerce> result = null; ECommerce guia = null; List <DetallesECommerce> lista = null; DataTable dt = null; try { using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexionEcommerce)) { try { using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ven_id", venta_id); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { dt = new DataTable(); da.Fill(dt); lista = new List <DetallesECommerce>(); lista = (from DataRow dr in dt.Rows select new DetallesECommerce() { codigoProducto = dr["codigoProducto"].ToString(), nombreProducto = dr["nombreProducto"].ToString(), cantidad = Convert.ToInt32(dr["cantidad"]), precioUnitario = Convert.ToDecimal(dr["precioUnitario"]), descuento = Convert.ToDecimal(dr["descuento"]), total = Convert.ToDecimal(dr["total"]), talla = dr["talla"].ToString(), }).ToList(); guia = new ECommerce(); guia.idPedido = dt.Rows[0]["idPedido"].ToString(); guia.Referencia = dt.Rows[0]["Referencia"].ToString(); guia.fechaPedido = Convert.ToDateTime(dt.Rows[0]["fechaPedido"]); guia.tipoComprobante = dt.Rows[0]["tipoComprobante"].ToString(); guia.SerieDoc = dt.Rows[0]["SerieDoc"].ToString(); guia.GuiaNro = dt.Rows[0]["GuiaNro"].ToString(); guia.NroDoc = dt.Rows[0]["NroDoc"].ToString(); guia.codSeguimiento = dt.Rows[0]["codSeguimiento"].ToString(); guia.nom_courier = dt.Rows[0]["nom_courier"].ToString(); guia.estado = dt.Rows[0]["estado"].ToString(); guia.cliente = dt.Rows[0]["cliente"].ToString(); guia.direccionA = dt.Rows[0]["direccionA"].ToString(); guia.direccionB = dt.Rows[0]["direccionB"].ToString(); guia.direccionCliente = dt.Rows[0]["direccionCliente"].ToString(); guia.referenciaCliente = dt.Rows[0]["referenciaCliente"].ToString(); guia.TpDocCli = dt.Rows[0]["TpDocCli"].ToString(); guia.noDocCli = dt.Rows[0]["noDocCli"].ToString(); guia.nombreCliente = dt.Rows[0]["nombreCliente"].ToString(); guia.apePatCliente = dt.Rows[0]["apePatCliente"].ToString(); guia.apeMatCliente = dt.Rows[0]["apeMatCliente"].ToString(); guia.nombreCompletoCliente = dt.Rows[0]["nombreCompletoCliente"].ToString(); guia.cod_entid = dt.Rows[0]["cod_entid"].ToString(); guia.nombreEstado = dt.Rows[0]["nombreEstado"].ToString(); guia.detalles = lista; /*****BarCode*****/ if (dt.Rows[0]["codSeguimiento"].ToString().Length > 0) { //Create an instance of Linear Barcode //Use DataMatrixCrystal for Data Matrix //Use PDF417Crystal for PDF417 //Use QRCodeCrystal for QR Code LinearCrystal barcode = new LinearCrystal(); //Barcode settings barcode.Type = BarcodeType.CODE128; barcode.BarHeight = 100; //50 pixels barcode.ImageFormat = System.Drawing.Imaging.ImageFormat.Png; barcode.Data = dt.Rows[0]["codSeguimiento"].ToString(); byte[] imageData = barcode.drawBarcodeAsBytes(); guia.BarCode = imageData; } /*****************/ } } } catch (Exception ex) { } } } catch { } result = new List <ECommerce>(); result.Add(guia); return(result); }
static void Main(string[] args) { // Scenario 1 Console.WriteLine("Scenario 1"); using (var context = new ModelSelfReference()) { context.Database.ExecuteSqlCommand("DELETE FROM [SelfReferences]"); context.SelfReferences.Add(new SelfReference { Name = "Test" }); context.SaveChanges(); context.SelfReferences.Add(new SelfReference { Name = "Test2", ParentSelfReference = context.SelfReferences.FirstOrDefault() }); context.SaveChanges(); } using (var context = new ModelSelfReference()) { foreach (var p in context.SelfReferences) { Console.WriteLine("{0} {1} {2}", p.SelfReferenceId, p.Name, p.ParentSelfReferenceId); } } // Scenario 2 Console.WriteLine("\nScenario 2"); using (var context = new ModelSelfReference()) { context.Database.ExecuteSqlCommand("DELETE FROM [BazaDeDate].[ProductWebInfo]"); context.SaveChanges(); context.Database.ExecuteSqlCommand("DELETE FROM [BazaDeDate].[Product]"); var product = new Product { SKU = 147, Description = "Expandable Hydration Pack", Price = 19.97M, ImageURL = "/pack147.jpg" }; context.Products.Add(product); product = new Product { SKU = 178, Description = "Rugged Ranger Duffel Bag", Price = 39.97M, ImageURL = "/pack178.jpg" }; context.Products.Add(product); product = new Product { SKU = 186, Description = "Range Field Pack", Price = 98.97M, ImageURL = "/noimage.jp" }; context.Products.Add(product); product = new Product { SKU = 202, Description = "Small Deployment Back Pack", Price = 29.97M, ImageURL = "/pack202.jpg" }; context.Products.Add(product); context.SaveChanges(); } using (var context = new ModelSelfReference()) { foreach (var p in context.Products) { Console.WriteLine("{0} {1} {2} {3}", p.SKU, p.Description, p.Price.ToString("C"), p.ImageURL); } } // scenario 3 example Console.WriteLine("\nScenario 3"); byte[] thumbBits = new byte[100]; byte[] fullBits = new byte[2000]; using (var context = new ModelSelfReference()) { var photo = new Photograph { Title = "My Dog", ThumbnailBits = thumbBits }; var fullImage = new PhotographFullImage { HighResolutionBits = fullBits }; photo.PhotographFullImage = fullImage; context.Photographs.Add(photo); context.SaveChanges(); } using (var context = new ModelSelfReference()) { foreach (var photo in context.Photographs) { Console.WriteLine("Photo: {0}, ThumbnailSize {1} bytes", photo.Title, photo.ThumbnailBits.Length); context.Entry(photo) .Reference(p => p.PhotographFullImage).Load(); Console.WriteLine("Full Image Size: {0} bytes", photo.PhotographFullImage.HighResolutionBits.Length); } } // Scenario 4 Console.WriteLine("\n Scenario 4"); using (var context = new ModelSelfReference()) { var business = new Business { Name = "Corner Dry Cleaning", LicenseNumber = "100x1" }; context.Businesses.Add(business); var retail = new Retail { Name = "Shop and Save", LicenseNumber = "200C", Address = "101 Main", City = "Anytown", State = "TX", ZIPCode = "76106" }; context.Businesses.Add(retail); var web = new ECommerce { Name = "BuyNow.com", LicenseNumber = "300AB", URL = "www.buynow.com" }; context.Businesses.Add(web); context.SaveChanges(); } using (var context = new ModelSelfReference()) { Console.WriteLine("\n--- All Businesses ---"); foreach (var b in context.Businesses) { Console.WriteLine("{0} (#{1})", b.Name, b.LicenseNumber); } Console.WriteLine("\n--- Retail Businesses ---"); foreach (var r in context.Businesses.OfType <Retail>()) { Console.WriteLine("{0} (#{1})", r.Name, r.LicenseNumber); Console.WriteLine("{0}", r.Address); Console.WriteLine("{0}, {1} {2}", r.City, r.State, r.ZIPCode); } Console.WriteLine("\n--- eCommerce Businesses ---"); foreach (var e in context.Businesses.OfType <ECommerce>()) { Console.WriteLine("{0} (#{1})", e.Name, e.LicenseNumber); Console.WriteLine("Online address is: {0}", e.URL); } } // Scenario 5 Console.WriteLine("\nScenario 5"); using (var context = new ModelSelfReference()) { var fte = new FullTimeEmployee { FirstName = "Jane", LastName = "Doe", Salary = 71500M }; context.Employees.Add(fte); fte = new FullTimeEmployee { FirstName = "John", LastName = "Smith", Salary = 62500M }; context.Employees.Add(fte); var hourly = new HourlyEmployee { FirstName = "Tom", LastName = "Jones", Wage = 8.75M }; context.Employees.Add(hourly); context.SaveChanges(); } using (var context = new ModelSelfReference()) { Console.WriteLine("--- All Employees ---"); foreach (var emp in context.Employees) { bool fullTime = emp is HourlyEmployee ? false : true; Console.WriteLine("{0} {1} ({2})", emp.FirstName, emp.LastName, fullTime ? "Full Time" : "Hourly"); } Console.WriteLine("--- Full Time ---"); foreach (var fte in context.Employees.OfType <FullTimeEmployee>()) { Console.WriteLine("{0} {1}", fte.FirstName, fte.LastName); } Console.WriteLine("--- Hourly ---"); foreach (var hourly in context.Employees.OfType <HourlyEmployee>()) { Console.WriteLine("{0} {1}", hourly.FirstName, hourly.LastName); } } }