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