本文整理汇总了C#中Maticsoft类的典型用法代码示例。如果您正苦于以下问题：C# Maticsoft类的具体用法？C# Maticsoft怎么用？C# Maticsoft使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
Maticsoft类属于命名空间，在下文中一共展示了Maticsoft类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Update
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.W_Material model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update W_Material set ");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected],");
strSql.Append("[email protected]");
strSql.Append(" where [email protected] ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4),
new SqlParameter("@Name", SqlDbType.NVarChar,100),
new SqlParameter("@Begindate", SqlDbType.DateTime),
new SqlParameter("@Enddate", SqlDbType.DateTime),
new SqlParameter("@Number", SqlDbType.VarChar,150),
new SqlParameter("@Address", SqlDbType.VarChar,150),
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
parameters[2].Value = model.Begindate;
parameters[3].Value = model.Enddate;
parameters[4].Value = model.Number;
parameters[5].Value = model.Address;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}示例2: AddEx
public bool AddEx(Maticsoft.Model.SNS.UserAlbumDetail model)
{
List<CommandInfo> cmdList = new List<CommandInfo>();
StringBuilder builder = new StringBuilder();
builder.Append("insert into SNS_UserAlbumDetail(");
builder.Append("AlbumID,TargetID,Type,Description,AlbumUserId)");
builder.Append(" values (");
builder.Append("@AlbumID,@TargetID,@Type,@Description,@AlbumUserId)");
builder.Append(";select @@IDENTITY");
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@AlbumID", SqlDbType.Int, 4), new SqlParameter("@TargetID", SqlDbType.Int, 4), new SqlParameter("@Type", SqlDbType.Int, 4), new SqlParameter("@Description", SqlDbType.NVarChar, 200), new SqlParameter("@AlbumUserId", SqlDbType.Int, 4) };
para[0].Value = model.AlbumID;
para[1].Value = model.TargetID;
para[2].Value = model.Type;
para[3].Value = model.Description;
para[4].Value = model.AlbumUserId;
CommandInfo item = new CommandInfo(builder.ToString(), para);
cmdList.Add(item);
StringBuilder builder2 = new StringBuilder();
builder2.Append("update SNS_UserAlbums set ");
builder2.Append("PhotoCount=PhotoCount+1 ");
builder2.Append(" where [email protected]");
SqlParameter[] parameterArray2 = new SqlParameter[] { new SqlParameter("@AlbumID", SqlDbType.Int, 4) };
parameterArray2[0].Value = model.AlbumID;
CommandInfo info2 = new CommandInfo(builder2.ToString(), parameterArray2);
cmdList.Add(info2);
if (DbHelperSQL.ExecuteSqlTran(cmdList) <= 0)
{
return false;
}
return true;
}示例3: Add
public int Add(Maticsoft.Model.Ms.Theme model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Ms_Theme(");
builder.Append("Name,Description,PreviewPhotoSrc,ZipPackageSrc,ThemeSize,Author,IsCurrent,Language,CreatedDate,Remark)");
builder.Append(" values (");
builder.Append("@Name,@Description,@PreviewPhotoSrc,@ZipPackageSrc,@ThemeSize,@Author,@IsCurrent,@Language,@CreatedDate,@Remark)");
builder.Append(";select @@IDENTITY");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar, 100), new SqlParameter("@Description", SqlDbType.NVarChar, 200), new SqlParameter("@PreviewPhotoSrc", SqlDbType.NVarChar, 100), new SqlParameter("@ZipPackageSrc", SqlDbType.NVarChar, 50), new SqlParameter("@ThemeSize", SqlDbType.Int, 4), new SqlParameter("@Author", SqlDbType.NVarChar, 100), new SqlParameter("@IsCurrent", SqlDbType.Bit, 1), new SqlParameter("@Language", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@Remark", SqlDbType.NVarChar, 100) };
cmdParms[0].Value = model.Name;
cmdParms[1].Value = model.Description;
cmdParms[2].Value = model.PreviewPhotoSrc;
cmdParms[3].Value = model.ZipPackageSrc;
cmdParms[4].Value = model.ThemeSize;
cmdParms[5].Value = model.Author;
cmdParms[6].Value = model.IsCurrent;
cmdParms[7].Value = model.Language;
cmdParms[8].Value = model.CreatedDate;
cmdParms[9].Value = model.Remark;
object single = Maticsoft.DBUtility.DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return 0;
}
return Convert.ToInt32(single);
}示例4: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.rolefun model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into rolefun(");
strSql.Append("roleid,funid,rolep)");
strSql.Append(" values (");
strSql.Append("@roleid,@funid,@rolep)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@roleid", SqlDbType.Int,4),
new SqlParameter("@funid", SqlDbType.Int,4),
new SqlParameter("@rolep", SqlDbType.Int,4)};
parameters[0].Value = model.roleid;
parameters[1].Value = model.funid;
parameters[2].Value = model.rolep;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例5: Add
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.District model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into District(");
strSql.Append("DistrictID,DistrictName,CityID,SortID)");
strSql.Append(" values (");
strSql.Append("@DistrictID,@DistrictName,@CityID,@SortID)");
SqlParameter[] parameters = {
new SqlParameter("@DistrictID", SqlDbType.NVarChar,50),
new SqlParameter("@DistrictName", SqlDbType.NVarChar,50),
new SqlParameter("@CityID", SqlDbType.NVarChar,50),
new SqlParameter("@SortID", SqlDbType.Int,4)};
parameters[0].Value = model.DistrictID;
parameters[1].Value = model.DistrictName;
parameters[2].Value = model.CityID;
parameters[3].Value = model.SortID;
int rows=ServerDbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}示例6: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.sys_Applications model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sys_Applications(");
strSql.Append("A_AppName,A_AppDescription,A_AppUrl,A_Order)");
strSql.Append(" values (");
strSql.Append("@A_AppName,@A_AppDescription,@A_AppUrl,@A_Order)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@A_AppName", SqlDbType.NVarChar,50),
new SqlParameter("@A_AppDescription", SqlDbType.NVarChar,200),
new SqlParameter("@A_AppUrl", SqlDbType.VarChar,50),
new SqlParameter("@A_Order", SqlDbType.Int,4)};
parameters[0].Value = model.A_AppName;
parameters[1].Value = model.A_AppDescription;
parameters[2].Value = model.A_AppUrl;
parameters[3].Value = model.A_Order;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例7: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.education_Prescription model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into education_Prescription(");
strSql.Append("P_Object,P_Name,P_Content,P_Doctor,P_Date)");
strSql.Append(" values (");
strSql.Append("@P_Object,@P_Name,@P_Content,@P_Doctor,@P_Date)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@P_Object", SqlDbType.Money,8),
new SqlParameter("@P_Name", SqlDbType.NVarChar,100),
new SqlParameter("@P_Content", SqlDbType.Text),
new SqlParameter("@P_Doctor", SqlDbType.Int,4),
new SqlParameter("@P_Date", SqlDbType.DateTime)};
parameters[0].Value = model.P_Object;
parameters[1].Value = model.P_Name;
parameters[2].Value = model.P_Content;
parameters[3].Value = model.P_Doctor;
parameters[4].Value = model.P_Date;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例8: Add
public int Add(Maticsoft.Model.Shop.Products.ProductReviews model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into Shop_ProductReviews(");
builder.Append("ProductId,UserId,ReviewText,UserName,UserEmail,CreatedDate,ParentId,Status,OrderId,SKU,Attribute,ImagesPath,ImagesNames)");
builder.Append(" values (");
builder.Append("@ProductId,@UserId,@ReviewText,@UserName,@UserEmail,@CreatedDate,@ParentId,@Status,@OrderId,@SKU,@Attribute,@ImagesPath,@ImagesNames)");
builder.Append(";select @@IDENTITY");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ProductId", SqlDbType.BigInt, 8), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@ReviewText", SqlDbType.NVarChar, -1), new SqlParameter("@UserName", SqlDbType.NVarChar, 200), new SqlParameter("@UserEmail", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedDate", SqlDbType.DateTime), new SqlParameter("@ParentId", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@OrderId", SqlDbType.BigInt, 8), new SqlParameter("@SKU", SqlDbType.NVarChar, 200), new SqlParameter("@Attribute", SqlDbType.Text), new SqlParameter("@ImagesPath", SqlDbType.NVarChar, 300), new SqlParameter("@ImagesNames", SqlDbType.NVarChar, 500) };
cmdParms[0].Value = model.ProductId;
cmdParms[1].Value = model.UserId;
cmdParms[2].Value = model.ReviewText;
cmdParms[3].Value = model.UserName;
cmdParms[4].Value = model.UserEmail;
cmdParms[5].Value = model.CreatedDate;
cmdParms[6].Value = model.ParentId;
cmdParms[7].Value = model.Status;
cmdParms[8].Value = model.OrderId;
cmdParms[9].Value = model.SKU;
cmdParms[10].Value = model.Attribute;
cmdParms[11].Value = model.ImagesPath;
cmdParms[12].Value = model.ImagesNames;
object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return 0;
}
return Convert.ToInt32(single);
}示例9: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.AR_Announcement model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into AR_Announcement(");
strSql.Append("A_Title,A_Content,A_DateTime,A_ResponsibilityUserID,A_Type,A_GroupID)");
strSql.Append(" values (");
strSql.Append("@A_Title,@A_Content,@A_DateTime,@A_ResponsibilityUserID,@A_Type,@A_GroupID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@A_Title", SqlDbType.NVarChar,255),
new SqlParameter("@A_Content", SqlDbType.Text),
new SqlParameter("@A_DateTime", SqlDbType.DateTime),
new SqlParameter("@A_ResponsibilityUserID", SqlDbType.Int,4),
new SqlParameter("@A_Type", SqlDbType.TinyInt,1),
new SqlParameter("@A_GroupID", SqlDbType.Int,4)};
parameters[0].Value = model.A_Title;
parameters[1].Value = model.A_Content;
parameters[2].Value = model.A_DateTime;
parameters[3].Value = model.A_ResponsibilityUserID;
parameters[4].Value = model.A_Type;
parameters[5].Value = model.A_GroupID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例10: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.MsgData model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into MsgData(");
strSql.Append("PhoneNumber,Msg,MsgTime,IsRecivedMsg,ReciveMsgStatus,ReturnedID)");
strSql.Append(" values (");
strSql.Append("@PhoneNumber,@Msg,@MsgTime,@IsRecivedMsg,@ReciveMsgStatus,@ReturnedID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@PhoneNumber", SqlDbType.NVarChar,50),
new SqlParameter("@Msg", SqlDbType.NVarChar,200),
new SqlParameter("@MsgTime", SqlDbType.DateTime),
new SqlParameter("@IsRecivedMsg", SqlDbType.Bit,1),
new SqlParameter("@ReciveMsgStatus", SqlDbType.NVarChar,50),
new SqlParameter("@ReturnedID", SqlDbType.NVarChar,50)};
parameters[0].Value = model.PhoneNumber;
parameters[1].Value = model.Msg;
parameters[2].Value = model.MsgTime;
parameters[3].Value = model.IsRecivedMsg;
parameters[4].Value = model.ReciveMsgStatus;
parameters[5].Value = model.ReturnedID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例11: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.Tao.CourseNotes model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tao_CourseNotes(");
strSql.Append("UserID,CourseID,ModuleID,Updatetime,Contents)");
strSql.Append(" values (");
strSql.Append("@UserID,@CourseID,@ModuleID,@Updatetime,@Contents)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserID", SqlDbType.Int,4),
new SqlParameter("@CourseID", SqlDbType.Int,4),
new SqlParameter("@ModuleID", SqlDbType.Int,4),
new SqlParameter("@Updatetime", SqlDbType.DateTime),
new SqlParameter("@Contents", SqlDbType.NVarChar,2000)};
parameters[0].Value = model.UserID;
parameters[1].Value = model.CourseID;
parameters[2].Value = model.ModuleID;
parameters[3].Value = model.Updatetime;
parameters[4].Value = model.Contents;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例12: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.supervision_Info model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into supervision_Info(");
strSql.Append("I_FindDate,I_Type,I_Content,I_ReportDate,I_ReportUserID)");
strSql.Append(" values (");
strSql.Append("@I_FindDate,@I_Type,@I_Content,@I_ReportDate,@I_ReportUserID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@I_FindDate", SqlDbType.DateTime),
new SqlParameter("@I_Type", SqlDbType.TinyInt,1),
new SqlParameter("@I_Content", SqlDbType.Text),
new SqlParameter("@I_ReportDate", SqlDbType.DateTime),
new SqlParameter("@I_ReportUserID", SqlDbType.Int,4)};
parameters[0].Value = model.I_FindDate;
parameters[1].Value = model.I_Type;
parameters[2].Value = model.I_Content;
parameters[3].Value = model.I_ReportDate;
parameters[4].Value = model.I_ReportUserID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例13: Add
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.CodeData model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CodeData(");
strSql.Append("Code,Remark,IsValidated,ValidatedTime,IsExchanged,ExchangeTime,PhoneNumber)");
strSql.Append(" values (");
strSql.Append("@Code,@Remark,@IsValidated,@ValidatedTime,@IsExchanged,@ExchangeTime,@PhoneNumber)");
SqlParameter[] parameters = {
new SqlParameter("@Code", SqlDbType.NVarChar,50),
new SqlParameter("@Remark", SqlDbType.NVarChar,50),
new SqlParameter("@IsValidated", SqlDbType.Bit,1),
new SqlParameter("@ValidatedTime", SqlDbType.DateTime),
new SqlParameter("@IsExchanged", SqlDbType.Bit,1),
new SqlParameter("@ExchangeTime", SqlDbType.DateTime),
new SqlParameter("@PhoneNumber", SqlDbType.NVarChar,50)};
parameters[0].Value = model.Code;
parameters[1].Value = model.Remark;
parameters[2].Value = model.IsValidated;
parameters[3].Value = model.ValidatedTime;
parameters[4].Value = model.IsExchanged;
parameters[5].Value = model.ExchangeTime;
parameters[6].Value = model.PhoneNumber;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}示例14: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.T_Batch model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into T_Batch(");
strSql.Append("name,subName,year,administratorArea,approvalAuthority,approvalNo,approvalTime,batchTypeId,totalArea,addConsArea,consArea,agriArea,arabArea,unusedArea,hasLevyArea,userId,createTime,isSubmited,isDeleted,des)");
strSql.Append(" values (");
strSql.Append("@name,@subName,@year,@administratorArea,@approvalAuthority,@approvalNo,@approvalTime,@batchTypeId,@totalArea,@addConsArea,@consArea,@agriArea,@arabArea,@unusedArea,@hasLevyArea,@userId,@createTime,@isSubmited,@isDeleted,@des)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@name", SqlDbType.VarChar,50),
new SqlParameter("@subName", SqlDbType.VarChar,50),
new SqlParameter("@year", SqlDbType.VarChar,50),
new SqlParameter("@administratorArea", SqlDbType.VarChar,50),
new SqlParameter("@approvalAuthority", SqlDbType.VarChar,50),
new SqlParameter("@approvalNo", SqlDbType.VarChar,50),
new SqlParameter("@approvalTime", SqlDbType.Date,3),
new SqlParameter("@batchTypeId", SqlDbType.Int,4),
new SqlParameter("@totalArea", SqlDbType.Decimal,9),
new SqlParameter("@addConsArea", SqlDbType.Decimal,9),
new SqlParameter("@consArea", SqlDbType.Decimal,9),
new SqlParameter("@agriArea", SqlDbType.Decimal,9),
new SqlParameter("@arabArea", SqlDbType.Decimal,9),
new SqlParameter("@unusedArea", SqlDbType.Decimal,9),
new SqlParameter("@hasLevyArea", SqlDbType.Decimal,9),
new SqlParameter("@userId", SqlDbType.Int,4),
new SqlParameter("@createTime", SqlDbType.DateTime),
new SqlParameter("@isSubmited", SqlDbType.Int,4),
new SqlParameter("@isDeleted", SqlDbType.Int,4),
new SqlParameter("@des", SqlDbType.Text)};
parameters[0].Value = model.name;
parameters[1].Value = model.subName;
parameters[2].Value = model.year;
parameters[3].Value = model.administratorArea;
parameters[4].Value = model.approvalAuthority;
parameters[5].Value = model.approvalNo;
parameters[6].Value = model.approvalTime;
parameters[7].Value = model.batchTypeId;
parameters[8].Value = model.totalArea;
parameters[9].Value = model.addConsArea;
parameters[10].Value = model.consArea;
parameters[11].Value = model.agriArea;
parameters[12].Value = model.arabArea;
parameters[13].Value = model.unusedArea;
parameters[14].Value = model.hasLevyArea;
parameters[15].Value = model.userId;
parameters[16].Value = model.createTime;
parameters[17].Value = model.isSubmited;
parameters[18].Value = model.isDeleted;
parameters[19].Value = model.des;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}示例15: Add
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.sys_RolePermission model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into sys_RolePermission(");
strSql.Append("P_RoleID,P_ApplicationID,P_PageCode,P_Value)");
strSql.Append(" values (");
strSql.Append("@P_RoleID,@P_ApplicationID,@P_PageCode,@P_Value)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@P_RoleID", SqlDbType.Int,4),
new SqlParameter("@P_ApplicationID", SqlDbType.Int,4),
new SqlParameter("@P_PageCode", SqlDbType.VarChar,20),
new SqlParameter("@P_Value", SqlDbType.Int,4)};
parameters[0].Value = model.P_RoleID;
parameters[1].Value = model.P_ApplicationID;
parameters[2].Value = model.P_PageCode;
parameters[3].Value = model.P_Value;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}