public int update(IConnection pConn, int pUpdateUserID)
{
this._UpdateBy = pUpdateUserID;
this._UpdateTime = DateTime.Now;
string SqlStr;
int result=0;
SqlStr = " UPDATE goods_groups SET " +
" GroupName = " + DbMgr.formatDbString(_GroupName) +
" ,IsActive = " + DbMgr.formatDbBool(_IsActive) +
" ,TypeID = " + DbMgr.formatDbID(_TypeID) +
" ,UpdateTime = " + DbMgr.formatDbDateTime(_UpdateTime) +
" ,UpdateBy = " + DbMgr.formatDbID(_UpdateBy) +
" WHERE GroupID = " + _GroupID.ToString() ;
result = pConn.exeNonQuery(SqlStr);
return result;
}
public int delete(IConnection pConn)
{
string SqlStr;
int result=0;
SqlStr = " DELETE FROM goods_groups" +
" WHERE GroupID = " + _GroupID.ToString() ;
result = pConn.exeNonQuery(SqlStr);
return result;
}
public int deActive(IConnection pConn, int pUpdateUserID)
{
this._UpdateBy = pUpdateUserID;
string SqlStr;
int result=0;
SqlStr = "UPDATE goods_groups SET IsActive = 'N' " +
" ,UpdateTime = " + DbMgr.formatDbGetDate() +
" ,UpdateBy = " + _UpdateBy.ToString() +
" WHERE GroupID = " + _GroupID.ToString() ;
result = pConn.exeNonQuery(SqlStr);
return result;
}
public int update(IConnection pConn, int pUpdateUserID)
{
this._UpdateBy = pUpdateUserID;
this._UpdateTime = DateTime.Now;
string SqlStr;
int result=0;
SqlStr = " UPDATE goods SET " +
" GoodsCode = " + DbMgr.formatDbString(_GoodsCode) +
" ,GoodsName = " + DbMgr.formatDbString(_GoodsName) +
" ,GoodsDesc = " + DbMgr.formatDbString(_GoodsDesc) +
" ,GoodsPcs = " + DbMgr.formatDbString(_GoodsPcs) +
" ,Price = " + _Price.ToString() +
" ,Qty = " + _Qty.ToString() +
" ,GoodsIMG = " + DbMgr.formatDbString(_GoodsIMG) +
" ,GroupID = " + DbMgr.formatDbID(_GroupID) +
" ,UpdateTime = " + DbMgr.formatDbDateTime(_UpdateTime) +
" ,UpdateBy = " + DbMgr.formatDbID(_UpdateBy) +
" WHERE GoodsCode = " + DbMgr.formatDbString(_OldGoodsCode) ;
result = pConn.exeNonQuery(SqlStr);
return result;
}
public int delete(IConnection pConn)
{
string SqlStr;
int result=0;
SqlStr = " DELETE FROM goods" +
" WHERE GoodsCode = " + DbMgr.formatDbString(_OldGoodsCode) ;
result = pConn.exeNonQuery(SqlStr);
return result;
}
public int add(IConnection pConn, int pCreateUserID)
{
this._CreateBy = pCreateUserID;
this._UpdateBy = pCreateUserID;
this._CreateTime = DateTime.Now;
this._UpdateTime = DateTime.Now;
string SqlStr;
int result = 0;
SqlStr = "INSERT INTO goods(GoodsCode, GoodsName, GoodsDesc, GoodsPcs, Price, Qty, GoodsIMG, GroupID, CreateTime, CreateBy, UpdateTime, UpdateBy) VALUES(" +
DbMgr.formatDbString(_GoodsCode) +
", " + DbMgr.formatDbString(_GoodsName) +
", " + DbMgr.formatDbString(_GoodsDesc) +
", " + DbMgr.formatDbString(_GoodsPcs) +
", " + DbMgr.formatDbDecimal(_Price) +
", " + _Qty.ToString() +
", " + DbMgr.formatDbString(_GoodsIMG) +
", " + DbMgr.formatDbID(_GroupID) +
", " + DbMgr.formatDbDateTime(_CreateTime) +
", " + DbMgr.formatDbID(_CreateBy) +
", " + DbMgr.formatDbDateTime(_UpdateTime) +
", " + DbMgr.formatDbID(_UpdateBy) +
")";
result = pConn.exeNonQuery(SqlStr);
return result;
}
