public int InsertDM_USER(DM_USER dm_user)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDUSER, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false));
para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false));
para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, dm_user.PASSWORD, false));
para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false));
para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false));
para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false));
para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false));
para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false));
para.Add(_DbHelper.CreateParameter(FIELD_NGAYTAO, dm_user.NGAYTAO, false));
para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("DM_USERDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public int InsertSYS_Province(SYS_Province sys_province)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_province.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, sys_province.ParentID, false));
para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_province.Code, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_Province_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ProvinceDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public int InsertDM_DVQLY(DM_DVQLY dm_dvqly)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_MA_DVIQLY, dm_dvqly.MA_DVIQLY, false));
para.Add(_DbHelper.CreateParameter(FIELD_TEN_DVIQLY, dm_dvqly.TEN_DVIQLY, false));
para.Add(_DbHelper.CreateParameter(FIELD_ParentId, dm_dvqly.ParentId, false));
para.Add(_DbHelper.CreateParameter(FIELD_TENVIETTAT, dm_dvqly.TenVietTat, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_DVQLY_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("DM_DVQLYDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public int InsertSYS_Catagory(SYS_Catagory SYS_Catagory, string tableName, string Connection)
{
SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess();
Connection = connect.DecryptSYS_ConfigConnection(Connection);
List <DbParameter> para = new List <DbParameter>();
DbConnection conn = _DbHelper.CreateConnection(Connection);
conn.Open();
try
{
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_NAME, SYS_Catagory.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_CODE, SYS_Catagory.Code, false));
para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false));
para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, SYS_Catagory.ParentID, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_Catagory_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_CatagoryDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public int InsertDM_MODULE(DM_MODULE dm_module)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDMODULE, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_module.IDMA_DVIQLY, false));
para.Add(_DbHelper.CreateParameter(FIELD_CONNECTSTRING, dm_module.ConnectString, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, dm_module.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_CODE, dm_module.Code, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_module.IDUSER, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_MODULE_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("DM_MODULEDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public int InsertSYS_CCU(SYS_CCU sys_ccu)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
try
{
List <DbParameter> para = new List <DbParameter>();
DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true);
para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_ccu.Time, false));
para.Add(_DbHelper.CreateParameter(FIELD_TOTALREQUEST, sys_ccu.TotalRequest, false));
para.Add(_DbHelper.CreateParameter(FIELD_TOTALONLINE, sys_ccu.TotalOnline, false));
para.Add(_DbHelper.CreateParameter(FIELD_ONLINE, sys_ccu.Online, false));
para.Add(ouput);
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_CCU_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_CCUDataAccess.Insert: {0}", ex.Message));
}
finally
{
conn.Close();
}
}
public bool UpdateEntity(Model.PurchaseOrdersModel entity)
{
string sql = string.Format("Update purchaseOrders Set orderNumber='{0}',supplier='{1}',person='{2}',telphone='{3}',address='{4}',contract='{5}',orderDate='{6}' Where id={7}",
entity.OrderNumber, entity.SupplierName, entity.Person, entity.Tel, entity.Address, entity.Contract, entity.OrderDate, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0);
}
public string InsertVertualTourDetails(Guid Gid, string virtualname, int userid, string link)
{
string result = "";
try
{
MSSqlHelper objMSSqlHelper = new MSSqlHelper();
objMSSqlHelper.Parameters.Add(new SqlParameter("@Vid", Gid));
objMSSqlHelper.Parameters.Add(new SqlParameter("@VirtualName", virtualname));
objMSSqlHelper.Parameters.Add(new SqlParameter("@UserId", userid));
objMSSqlHelper.Parameters.Add(new SqlParameter("@Link", link));
SqlParameter IdParam = new SqlParameter("@Msg", SqlDbType.Int);
IdParam.Direction = ParameterDirection.Output;
objMSSqlHelper.Parameters.Add(IdParam);
objMSSqlHelper.ExecuteNonQuery("SpInsertVertualDetails");
result = IdParam.Value.ToString();
if (result == "2")
{
result = "2";
}
else if (result == "")
{
result = Gid.ToString();
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public bool UpdateEntity(Model.SalesCommodityModel entity)
{
string sql = string.Format("update salesCommodity set orderId={0},commodityId={1},count={2},salesPrice={3},totalPrice={4} where id={5}",
entity.SalesOrderID, entity.CommodityID, entity.Count, entity.SalesPrice, entity.TotalPrice, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null) > 0);
}
public bool UpdateEntity(Model.CustomerModel entity)
{
string sql = string.Format("update customer set name='{0}',birthday='{1}',address='{2}',telphone='{3}',totalMoney='{4}',remark='{5}' where id={6}",
entity.Name, entity.Birthday, entity.Address, entity.Telphone, entity.TotalMoney, entity.Mark, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0);
}
public bool UpdateEntity(Model.CommodityModel entity)
{
string sql = string.Format("update Commodity set Name='{0}',Type='{1}',Manufacturer='{2}',Inventory={3},UnitPrice={4},Unit='{5}' where ID={6}",
entity.Name, entity.Type, entity.Manufacturer, entity.Inventory, entity.UnitPrice, entity.Unit, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0);
}
public bool UpdateEntity(Model.ManufacturerModel entity)
{
string sql = string.Format("update manufacturer set name='{0}',person='{1}',telephone='{2}',address={3},status={4} where ID={5}",
entity.Name, entity.Person, entity.Telphone, entity.Address, entity.Status, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0);
}
public bool UpdateEntity(SalesOrdersModel entity)
{
//OrderNumber 这儿写上吧，实际业务里不能被修改
string sql = string.Format("Update salesOrders Set orderNumber='{0}',customerId={1},customerName='{2}',telphone='{3}',address='{4}',contract='{5}',orderDate='{6}' Where id={7}",
entity.OrderNumber, entity.CustomerId, entity.CustomerName, entity.Tel, entity.Address, entity.Contract, entity.OrderDate, entity.ID);
return(MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0);
}
public int UpdateSYS_OrganizationPositionRole(List <SYS_OrganizationPositionRole> sys_organizationpositionroles)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_OrganizationPositionRole sys_organizationpositionrole in sys_organizationpositionroles)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ORGANIZATIONID, sys_organizationpositionrole.OrganizationId, false));
para.Add(_DbHelper.CreateParameter(FIELD_POSITIONID, sys_organizationpositionrole.PositionId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_organizationpositionrole.RoleId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_organizationpositionrole.ID, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_organizationpositionrole_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_OrganizationPositionRoleDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_Language(List <SYS_Language> sys_languages)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_Language sys_language in sys_languages)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_language.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_language.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_language.Code, false));
para.Add(_DbHelper.CreateParameter(FIELD_ISDEFAULT, sys_language.IsDefault, false));
para.Add(_DbHelper.CreateParameter(FIELD_PATH, sys_language.Path, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_language_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_LanguageDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_Staff(List <SYS_Staff> sys_staffs)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_Staff sys_staff in sys_staffs)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ORGANIZATIONID, sys_staff.OrganizationId, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_staff.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_POSITIONID, sys_staff.PositionId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_staff.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_FROMDATE, sys_staff.FromDate, false));
para.Add(_DbHelper.CreateParameter(FIELD_TODATE, sys_staff.ToDate, false));
para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_staff.RoleID, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_staff_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_StaffDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_Region_Province(List <SYS_Region_Province> sys_region_provinces)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_Region_Province sys_region_province in sys_region_provinces)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_region_province.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDREGION, sys_region_province.IDRegion, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDPROVINCE, sys_region_province.IDProvince, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_region_province_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_Region_ProvinceDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_CategoryManager(List <SYS_CategoryManager> sys_categorymanagers)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_CategoryManager sys_categorymanager in sys_categorymanagers)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_categorymanager.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, sys_categorymanager.TableName, false));
para.Add(_DbHelper.CreateParameter(FIELD_DISPLAYNAME, sys_categorymanager.DisplayName, false));
para.Add(_DbHelper.CreateParameter(FIELD_LINK, sys_categorymanager.Link, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_categorymanager_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_CategoryManagerDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_Right(List <SYS_Right> sys_rights)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_Right sys_right in sys_rights)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_right.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false));
para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false));
para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false));
para.Add(_DbHelper.CreateParameter(FIELD_FuncID, sys_right.FuncId, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_right_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RightDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_UserConfig(List <SYS_UserConfig> sys_userconfigs)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_UserConfig sys_userconfig in sys_userconfigs)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_LANGID, sys_userconfig.LangId, false));
para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_userconfig.UserId, false));
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_userconfig.ID, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_userconfig_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_UserConfigDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_Position(List <SYS_Position> sys_positions)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_Position sys_position in sys_positions)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_position.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_position.Name, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_position_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_PositionDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
public int UpdateSYS_ColumnCategory(List <SYS_ColumnCategory> sys_columncategorys)
{
DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString);
conn.Open();
int count = 0;
try
{
foreach (SYS_ColumnCategory sys_columncategory in sys_columncategorys)
{
List <DbParameter> para = new List <DbParameter>();
para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_columncategory.ID, false));
para.Add(_DbHelper.CreateParameter(FIELD_COLUMNNAME, sys_columncategory.ColumnName, false));
para.Add(_DbHelper.CreateParameter(FIELD_DISPLAYNAME, sys_columncategory.DisplayName, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDCATEGORYMANAGER, sys_columncategory.IDCategoryManager, false));
para.Add(_DbHelper.CreateParameter(FIELD_ALLOWNULL, sys_columncategory.AllowNull, false));
para.Add(_DbHelper.CreateParameter(FIELD_DATATYPE, sys_columncategory.DataType, false));
_DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[sys_columncategory_Update]", para.ToArray());
count++;
}
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_ColumnCategoryDataAccess.Update: {0}", ex.Message));
}
finally
{
conn.Close();
}
return(count);
}
//private int GetNewID()
//{
// string sql = "select s_Customer.nextval from dual";
// return int.Parse(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, sql, null).ToString());
//}
public Model.CustomerModel AddEntity(Model.CustomerModel entity)
{
string sql = string.Format(@"insert into customer(name,birthday,address,telphone,totalMoney,remark)
values({0},'{1}','{2}','{3}',{4},{5})", entity.Name, entity.Birthday, entity.Address, entity.Telphone, entity.TotalMoney, entity.Mark);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
public Model.SalesCommodityModel AddEntity(Model.SalesCommodityModel entity)
{
string sql = string.Format("insert into salesCommodity(orderId,commodityId,count,salesPrice,totalPrice) values({0},{1},{2},{3},{4})",
entity.SalesOrderID, entity.CommodityID, entity.Count, entity.SalesPrice, entity.TotalPrice);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
public Model.ManufacturerModel AddEntity(Model.ManufacturerModel entity)
{
string sql = string.Format(@"insert into manufacturer(name,person,telephone,address)
values({0},'{1}','{2}','{3}')", entity.Name, entity.Person, entity.Telphone, entity.Address);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
public Model.CommodityModel AddEntity(Model.CommodityModel entity)
{
entity.ID = GetNewID();
string sql = string.Format(@"insert into Commodity(ID,Name,Type,Manufacturer,Inventory,UnitPrice,Unit)
values({0},'{1}','{2}','{3}',{4},{5},'{6}')", entity.ID, entity.Name, entity.Type, entity.Manufacturer, entity.Inventory, entity.UnitPrice, entity.UnitPrice);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0)
{
return(entity);
}
else
{
return(null);
}
}
public SalesOrdersModel AddEntity(SalesOrdersModel entity)
{
string sql = string.Format("insert into salesOrders(orderNumber,customerId,customerName,telphone,address,contract,orderDate) values('{0}',{1},'{2}','{3}','{4}','{5}','{6}')",
entity.OrderNumber, entity.CustomerId, entity.CustomerName, entity.Tel, entity.Address, entity.Contract, entity.OrderDate);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null) > 0)
{
int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('salesOrders')", null).ToString());
entity.ID = curID;
return(entity);
}
else
{
return(null);
}
}
public Model.PurchaseCommodityModel AddEntity(Model.PurchaseCommodityModel entity)
{
string sql = string.Format("insert into purchaseCommodity(orderId,commodityId,count,purchasePrice,totalPrice) values({0},{1},{2},{3},{4})",
entity.PurchaseOrderID, entity.CommodityID, entity.Count, entity.PurchasePrice, entity.TotalPrice);
if (MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, System.Data.CommandType.Text, sql, null) > 0)
{
//int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('purchasecommodity')", null).ToString());
//entity.ID = curID;
return(entity);
}
else
{
return(null);
}
}
public Model.PurchaseOrdersModel AddEntity(Model.PurchaseOrdersModel entity)
{
string sql = string.Format("insert into purchaseOrders(orderNumber,supplier,person,telphone,address,contract,OrderDate) values({0},'{1}','{2}','{3}','{4}','{5}','{6}')",
entity.OrderNumber, entity.SupplierName, entity.Person, entity.Tel, entity.Address, entity.Contract, entity.OrderDate);
int resRows = MSSqlHelper.ExecuteNonQuery(MSSqlHelper.ConStr, CommandType.Text, sql, null);
if (resRows > 0)
{
int curID = Convert.ToInt32(MSSqlHelper.ExecuteScalar(MSSqlHelper.ConStr, CommandType.Text, "select ident_current('purchaseOrders')", null).ToString());
entity.ID = curID;
return(entity);
}
else
{
return(null);
}
}
public int DeleteTourByVID(string vid, int userid)
{
int result = 0;
try
{
MSSqlHelper objMSSqlHelper = new MSSqlHelper();
objMSSqlHelper.Parameters.Add(new SqlParameter("@Vid", vid));
objMSSqlHelper.Parameters.Add(new SqlParameter("@UserId", userid));
result = Convert.ToInt32(objMSSqlHelper.ExecuteNonQuery("DeleteTourByVid"));
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
