protected void gvRecords_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int rowid = Convert.ToInt32(gvRecords.DataKeys[e.RowIndex].Value.ToString());
DropDownList ddlGvClient = (DropDownList)gvRecords.Rows[e.RowIndex].FindControl("ddlGvClient");
DropDownList ddlGvTask = (DropDownList)gvRecords.Rows[e.RowIndex].FindControl("ddlGvTask");
DropDownList ddlGvSubTask = (DropDownList)gvRecords.Rows[e.RowIndex].FindControl("ddlGvSubTask");
TextBox txtComments = (TextBox)gvRecords.Rows[e.RowIndex].FindControl("txtComments");
//Namohar code changes on 10-Aug-2016.
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@client", ddlGvClient.SelectedValue),
new SqlParameter("@task", ddlGvTask.SelectedValue),
new SqlParameter("@subTask", ddlGvSubTask.SelectedValue),
new SqlParameter("@comments", txtComments.Text),
new SqlParameter("@rowid", rowid)
};
SQlQuery = "UPDATE RTM_Records SET R_Client =@client, R_Task=@task, R_SubTask =@subTask, R_Comments=@comments where R_ID=@rowid";
result = objDB.ExecuteNonQuery(SQlQuery, CommandType.Text, parameters);
gvRecords.EditIndex = -1;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Update Record", "alert('Updated Successfully')", true);
DisplayRecords();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
lblError.ForeColor = Color.Red;
gvRecords.EditIndex = -1;
DisplayRecords();
}
}
public ResultInfo SaveIcon(int iconNumber, string iconName, FileInfo file)
{
byte[] bytes = BinaryHelper.FileToBytes(file.FullName);
if (bytes == null)
{
return(ResultInfo.Fail);
}
SqlDBHelper sqlHelper = new SqlDBHelper();
sqlHelper.BeginTran();
try
{
string sqlStr = @"update sadDTICON set IconImage=@IconImage where iconNumber=@iconNumber";
SqlParameter[] pars = GetPars(iconNumber, bytes);
int line = sqlHelper.ExecuteNonQuery(sqlStr, pars);
if (line == 1)
{
sqlHelper.CommitTran();
return(ResultInfo.Cover);
}
else if (line > 1)
{
sqlHelper.RollBackTran();
return(ResultInfo.Fail);
}
else
{
//新增
if (iconNumber == 0)
{
iconNumber = Convert.ToInt32(sqlHelper.ExecuteScalar("select max(IconNumber)+1 from sadDTICON"));
}
if (iconName == "")
{
iconName = file.Name;
}
int calc_No = Convert.ToInt32(sqlHelper.ExecuteScalar("select max(Calc_No)+1 from sadDTICON"));
sqlStr = string.Format("insert into sadDTICON values ({0},1,@IconImage,'{1}',1,13,GETDATE())",
iconNumber, iconName);
pars = GetPars(iconNumber, bytes);
int lineIns = sqlHelper.ExecuteNonQuery(sqlStr, pars);
if (lineIns == 1)
{
sqlHelper.CommitTran();
return(ResultInfo.Increase);
}
else
{
sqlHelper.RollBackTran();
return(ResultInfo.Fail);
}
}
}
catch (Exception ex)
{
sqlHelper.RollBackTran();
throw ex;
}
}
public ResultInfo SaveIcon(int iconNumber, string iconName,FileInfo file)
{
byte[] bytes = BinaryHelper.FileToBytes(file.FullName);
if (bytes == null)
{
return ResultInfo.Fail;
}
SqlDBHelper sqlHelper = new SqlDBHelper();
sqlHelper.BeginTran();
try
{
string sqlStr = @"update sadDTICON set IconImage=@IconImage where iconNumber=@iconNumber";
SqlParameter[] pars = GetPars(iconNumber, bytes);
int line = sqlHelper.ExecuteNonQuery(sqlStr, pars);
if(line==1)
{
sqlHelper.CommitTran();
return ResultInfo.Cover;
}
else if (line > 1)
{
sqlHelper.RollBackTran();
return ResultInfo.Fail;
}
else
{
//新增
if (iconNumber == 0)
{
iconNumber =Convert.ToInt32( sqlHelper.ExecuteScalar("select max(IconNumber)+1 from sadDTICON"));
}
if (iconName=="")
{
iconName = file.Name;
}
int calc_No = Convert.ToInt32(sqlHelper.ExecuteScalar("select max(Calc_No)+1 from sadDTICON"));
sqlStr = string.Format("insert into sadDTICON values ({0},1,@IconImage,'{1}',1,13,GETDATE())",
iconNumber, iconName);
pars = GetPars(iconNumber, bytes);
int lineIns = sqlHelper.ExecuteNonQuery(sqlStr, pars);
if (lineIns == 1)
{
sqlHelper.CommitTran();
return ResultInfo.Increase;
}
else
{
sqlHelper.RollBackTran();
return ResultInfo.Fail;
}
}
}
catch(Exception ex)
{
sqlHelper.RollBackTran();
throw ex;
}
}
public bool AddClockOut(string recId, DateTime endTime, string duration, string comments)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@recId", recId),
new SqlParameter("@endTime", endTime),
new SqlParameter("@duration", duration),
new SqlParameter("@comments", comments)
};
sQuery = "update RTM_Records set R_Duration=@duration, R_CreatedOn=@endTime, R_Status ='Completed', R_Comments=@comments where R_ID =@recId";
result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
return(result);
}
public bool Add()
{
string StrSql = string.Format(@"INSERT INTO reduceGoods(F_proID,Reduce_Sum,Mode,Reduce_date,Why,ClearIncome,ClearCost,CustomerID,Detail)VALUES
('{0}','{1}','{2}','{3}','{4}', '{5}','{6}','{7}','{8}')", this.F_proID, this.Reduce_Sum, this.Mode, this.Reduce_date, this.Why, this.ClearIncome, this.ClearCost, this.CustomerID, this.Detail);
return(SqlDBHelper.ExecuteNonQuery(StrSql));
}
public bool Add()
{
string sqlstr = string.Format("insert Goods(F_proID,GoodsID ,GoodsName,ClassID,OldInfo,Type,MakeName,OldMonth,IntoDate,RepID,DepID,State,AddType,Quantity,JingCanZhi,OrderUnit,Price,Detail,Money,Pro_value) select'{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}' ,'{13}','{14}','{15}','{16}','{17}','{18}','{19}'",
this.F_proID, this.GoodsID, this.GoodsName, this.ClassID, this.OldInfo, this.Type, this.MakeName, this.OldMonth, this.IntoDate, this.RepID, DepID, this.State, this.AddType, this.Quantity, this.JingCanZhi, this.OrderUnit, this.Price, this.Detail, this.Money, this.Pro_value);
return(SqlDBHelper.ExecuteNonQuery(sqlstr));
}
protected void gvEmployee_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
bool result;
string empid = ((Label)gvEmployee.Rows[e.RowIndex].FindControl("lblEmpId")).Text;
DateTime login = Convert.ToDateTime(((TextBox)gvEmployee.Rows[e.RowIndex].FindControl("txtSCHLogin")).Text);
DateTime logout = Convert.ToDateTime(((TextBox)gvEmployee.Rows[e.RowIndex].FindControl("txtSCHLogout")).Text);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@login", login),
new SqlParameter("@logout", logout),
new SqlParameter("@empid", empid)
};
SQlQuery = "UPDATE RTM_User_List SET UL_SCH_Login=@login, UL_SCH_Logout=@logout where UL_Employee_Id =@empid";
result = objDB.ExecuteNonQuery(SQlQuery, CommandType.Text, parameters);
lblError.Text = "Updated Succesfully";
lblError.ForeColor = System.Drawing.Color.Blue;
//con.Close();
gvEmployee.EditIndex = -1;
BindGrid();
}
catch (Exception)
{
lblError.Text = "Something went wrong..Please try again";
lblError.ForeColor = System.Drawing.Color.Red;
}
}
protected void gvRecords_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int rowid = Convert.ToInt32(gvRecords.DataKeys[e.RowIndex].Value.ToString());
DropDownList ddlGvClient = (DropDownList)gvRecords.Rows[e.RowIndex].FindControl("ddlGvClient");
DropDownList ddlGvTask = (DropDownList)gvRecords.Rows[e.RowIndex].FindControl("ddlGvTask");
DropDownList ddlGvSubTask = (DropDownList)gvRecords.Rows[e.RowIndex].FindControl("ddlGvSubTask");
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@client", ddlGvClient.SelectedValue),
new SqlParameter("@task", ddlGvTask.SelectedValue),
new SqlParameter("@subtask", ddlGvSubTask.SelectedValue),
new SqlParameter("@id", rowid)
};
sQuery = "update rtm_records set R_Client=@client, R_Task=@task , R_SubTask=@subtask where R_ID = @id";
bool result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Update Record", "alert('Updated Successfully')", true);
gvRecords.EditIndex = -1;
getRecords();
}
catch (Exception)
{
}
}
public bool Update()
{
string StrSql = string.Format(@"UPDATE [dbo].[Borrow] SET [F_proID] = '{0}',[Borrow_sum] = '{1}',[Borrow_Date] = '{2}',[Predict_date] = '{3}',[NowDate] = '{4}'
,[Predict_money] = '{5}',[Money] = '{6}',[Company] = '{7}',[CustomerID] = '{8}',[Detail] = '{9}' WHERE ID='{10}'",
this.F_proID, this.Borrow_sum, this.Borrow_Date, this.Predict_date, this.NowDate, this.Predict_money, this.Money, this.Company, this.CustomerID, this.Detail, this.BorrowID);
return(SqlDBHelper.ExecuteNonQuery(StrSql));
}
public bool Add()
{
string StrSql = string.Format(@"INSERT INTO borrow(F_proID,Borrow_sum,Borrow_Date,Predict_date,NowDate,Predict_money,Money,Company,CustomerID,Detail)VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')"
, this.F_proID, this.Borrow_sum, this.Borrow_Date,
this.Predict_date, this.NowDate, this.Predict_money, this.Money, this.Company, this.CustomerID, this.Detail);
return(SqlDBHelper.ExecuteNonQuery(StrSql));
}
public bool Add()
{
string StrSql = string.Format(@"INSERT INTO Service ([F_proID],[Service_sum],[Service_Date],[Predict_date],[NowDate],[Cost],[NowCost],[Company]
,[Breakdown],[Service_txt],[Detail])VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')",
this.F_proID, this.Service_sum, this.Service_Date, this.Predict_date, this.NowDate, this.Cost, this.NowCost, this.Company,
this.Breakdown, this.Service_txt, this.Detail);
return(SqlDBHelper.ExecuteNonQuery(StrSql));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
int checkedValue = 0;
string check = "";
//Namohar code changes on 10-Aug-2016.
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@checkedValue", checkedValue),
new SqlParameter("@team", ddlTeam.SelectedValue),
};
if (ddlTeam.SelectedIndex == 0)
{
lblError.Text = "Please select Team";
lblError.ForeColor = System.Drawing.Color.Red;
}
else
{
if (rbNo.Checked == true)
{
checkedValue = 0;
check = "No";
}
else if (rbYes.Checked == true)
{
checkedValue = 1;
check = "Yes";
}
SQlQuery = "UPDATE RTM_Team_List SET T_Status =@checkedValue WHERE T_ID =@team";
result = objDB.ExecuteNonQuery(SQlQuery, CommandType.Text, parameters);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "RTM Comments Updated", "alert('RTM Comments for " + ddlTeam.SelectedItem.Text + " is set to " + check + "')", true);
//lblError.Text = "Updated Successfully";
//lblError.ForeColor = System.Drawing.Color.Blue;
}
}
catch (Exception)
{
lblError.Text = "Failed.. Please try again";
lblError.ForeColor = System.Drawing.Color.Red;
}
}
public bool Update()
{
string StrSql = string.Format(@"UPDATE Goods SET[F_proID] = '{0}',[GoodsName] = '{1}',
[ClassID] = '{2}',[Type] = '{3}' ,[MakeName] = '{4}',[OldMonth] = '{5}',[IntoDate] = '{6}',[RepID] = '{7}'
,[DepID] = '{8}',[State] = '{9}',[AddType] = '{10}',[Quantity] = '{11}',[JingCanZhi] = '{12}'
,[OrderUnit] = '{13}',[Price] = '{14}',[Detail] = '{15}',[Money] = '{16}',[Pro_value] = '{17}'
WHERE GoodsID = '{18}'", this.F_proID, this.GoodsName, this.ClassID, this.Type, this.MakeName, this.OldMonth,
this.IntoDate, this.RepID, this.DepID, this.State, this.AddType, this.Quantity, this.JingCanZhi, this.OrderUnit
, this.Price, this.Detail, this.Money, this.Pro_value, this.GoodsID);
return(SqlDBHelper.ExecuteNonQuery(StrSql));
}
public bool DeleteEstRecord(string recId)
{
bool result;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@recId", recId)
};
sQuery = "Delete from RTM_Estimation where EST_ID=@recId";
result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
return(result);
}
public bool IPAssign(string _fileId, string _status, string _assignedBy, string _assignedTo, string createdOn)
{
bool result;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@fileId", _fileId),
new SqlParameter("@status", _status),
new SqlParameter("@assignedBy", _assignedBy),
new SqlParameter("@assignedTo", _assignedTo),
new SqlParameter("@createdOn", createdOn)
};
string sQuery = "Insert into EMSDB_InvDetails (IND_FI, IND_Status, IND_IP_Assigned_By, IND_IP_Processed_By, IND_IP_CreatedOn) values(@fileId, @status, @assignedBy, @assignedTo, @createdOn)";
result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
//result = objDB.DBExecuteNoNQuery(sQuery);
return(result);
}
public int DeleteMainSkill(int Id)
{
int success = 0;
try
{
object[] param = { Id };
success = SqlDBHelper.ExecuteNonQuery(_connection, StoredProcedures.sp_DeleteMainSkill,
param);
}
catch (Exception ex)
{
}
return(success);
}
public int SaveUserAccount(UserAccount userAccount)
{
int success = 0;
try
{
object[] param = null;
success = SqlDBHelper.ExecuteNonQuery(_connection, StoredProcedures.sp_CreateUserAccount,
param);
}
catch (Exception ex)
{
}
return(success);
}
public bool StudentInfoInsert(StudentInfoObj StudentInformation)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Name", StudentInformation.Name),
new SqlParameter("@ID", StudentInformation.ID),
new SqlParameter("@Dept", StudentInformation.Dept),
new SqlParameter("@Gender", StudentInformation.Gender),
new SqlParameter("@CompletedCredit", StudentInformation.Completedcredit),
new SqlParameter("@Semester", StudentInformation.Semester),
new SqlParameter("@Cgpa", StudentInformation.Cgpa),
new SqlParameter("@Password", StudentInformation.Password),
};
return(SqlDBHelper.ExecuteNonQuery("StudentInfoInsert", CommandType.StoredProcedure, parameters));
}
public bool InsertQuestion(QuestionObj question)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ExamTopic", question.ExamTopic),
new SqlParameter("@ExamNumber", question.ExamNumber),
new SqlParameter("@QuestionNumber", question.QuestionNumber),
new SqlParameter("@QuestionText", question.QuestionText),
new SqlParameter("@Option1", question.Option1),
new SqlParameter("@Option2", question.Option2),
new SqlParameter("@Option3", question.Option3),
new SqlParameter("@Option4", question.Option4),
new SqlParameter("@CorrectAnswer", question.CorrectAnswer)
};
return(SqlDBHelper.ExecuteNonQuery("QuestionInsert", CommandType.StoredProcedure, parameters));
}
public int SaveMainSkill(MainSkill mainSkill)
{
int success = 0;
try
{
object[] param = { mainSkill.MainSkillName,
mainSkill.MainSkillDesctiption,
mainSkill.Active,
mainSkill.CreatedBy };
success = SqlDBHelper.ExecuteNonQuery(_connection, StoredProcedures.sp_CreateMainSkill,
param);
}
catch (Exception ex)
{
}
return(success);
}
private static bool UpdateTicketStatus(string gid, int status)
{
bool result = false;
SqlDBHelper dbHelper = new SqlDBHelper();
string updateStatusSqlTxt = String.Format(UpdateTicketStatusSqlCmd, status, gid);
try
{
if (dbHelper.ExecuteNonQuery(updateStatusSqlTxt) > 0)
{
result = true;
}
}
catch
{
}
return(result);
}
public bool AddNewClient(string teamId, string client, string jobCode, string corePlatform, string clientCode, string createdBy)
{
bool result;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@teamId", teamId),
new SqlParameter("@client", client),
new SqlParameter("@jobCode", jobCode),
new SqlParameter("@corePlatform", corePlatform),
new SqlParameter("@clientCode", clientCode),
new SqlParameter("@createdBy", createdBy),
new SqlParameter("@createdOn", DateTime.Now),
new SqlParameter("@status", "1")
};
sQuery = "insert into RTM_Client_List (CL_TeamId, CL_ClientName, CL_CreatedOn, CL_Status, CL_TSheetClient, CL_Product, CL_Code, CL_CreatedBy) values (@teamId, @client, @createdOn, @status, @jobCode, @corePlatform, @clientCode, @createdBy)";
result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
return(result);
}
public bool SaveIcon(List <IconBKInfo> iconList, string strSql)
{
SqlDBHelper sqlHelper = new SqlDBHelper();
sqlHelper.BeginTran();
try
{
sqlHelper.InsertOrUpdateTList <IconBKInfo>(iconList);
sqlHelper.ExecuteNonQuery(strSql);
sqlHelper.CommitTran();
//sqlHelper.RollBackTran(); /////////////////////////////////////////////////////////////////////////////////
return(true);
}
catch (Exception ex)
{
sqlHelper.RollBackTran();
throw ex;
}
}
public ResultInfo SaveIcon(List <HQSadDTICONInfo> sadDTIconList)
{
_sqlHelper.BeginTran();
try
{
foreach (HQSadDTICONInfo sadDTIcon in sadDTIconList)
{
List <SqlParameter> pars = new List <SqlParameter>();
pars.Add(SqlDBHelper.GetPar("Storenum", SqlDbType.NVarChar, sadDTIcon.Storenum));
pars.Add(SqlDBHelper.GetPar("IconNumber", SqlDbType.NVarChar, sadDTIcon.IconNumber));
pars.Add(SqlDBHelper.GetPar("effective_Date", SqlDbType.DateTime, sadDTIcon.effective_Date));
pars.Add(SqlDBHelper.GetPar("strgroup", SqlDbType.Int, sadDTIcon.strgroup));
pars.Add(SqlDBHelper.GetPar("upd_seq", SqlDbType.Int, sadDTIcon.upd_seq));
pars.Add(SqlDBHelper.GetPar("IconName", SqlDbType.NVarChar, sadDTIcon.IconName));
pars.Add(SqlDBHelper.GetPar("Status", SqlDbType.Bit, sadDTIcon.Status));
pars.Add(SqlDBHelper.GetPar("UpUser", SqlDbType.Int, sadDTIcon.UpUser));
pars.Add(SqlDBHelper.GetPar("UpDT", SqlDbType.DateTime, sadDTIcon.UpDT));
pars.Add(SqlDBHelper.GetPar("Editor", SqlDbType.NVarChar, sadDTIcon.Editor));
pars.Add(SqlDBHelper.GetPar("IconType", SqlDbType.Int, sadDTIcon.IconType));
pars.Add(SqlDBHelper.GetPar("deleted", SqlDbType.VarChar, sadDTIcon.deleted));
string cmdStr = string.Format(@"
DELETE FROM _upd_sadDTICON WHERE Storenum=@Storenum AND IconNumber=@IconNumber AND effective_Date=@effective_Date AND strgroup=@strgroup ;
INSERT INTO _upd_sadDTICON(
[upd_seq],[Storenum],[IconNumber],[IconName],[Status],[effective_Date],[UpUser],[UpDT],[Editor],[IconType],[strgroup],[deleted]
)
VALUES(
@upd_seq,@Storenum,@IconNumber,@IconName,@Status,@effective_Date,@UpUser,@UpDT,@Editor,@IconType,@strgroup,@deleted
) ;"
);
_sqlHelper.ExecuteNonQuery(cmdStr, pars.ToArray());
}
_sqlHelper.CommitTran();
return(ResultInfo.Success);
}
catch (Exception ex)
{
_sqlHelper.RollBackTran();
return(ResultInfo.Fail);
}
}
public bool InsertResult(ResultObj res)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@StudentID", res.StudentID),
new SqlParameter("@ExamTopic", res.ExamTopic),
new SqlParameter("@ExamNumber", res.ExamNumber),
new SqlParameter("@QuestionNumber", res.QuestionNumber),
new SqlParameter("@QuestionText", res.QuestionText),
new SqlParameter("@Option1", res.Option1),
new SqlParameter("@Option2", res.Option2),
new SqlParameter("@Option3", res.Option3),
new SqlParameter("@Option4", res.Option4),
new SqlParameter("@CorrectAnswer", res.CorrectAnswer),
new SqlParameter("@YourAnswer", res.YourAnswer),
new SqlParameter("@Result", res.Result)
};
return(SqlDBHelper.ExecuteNonQuery("ResultInsert", CommandType.StoredProcedure, parameters));
}
public bool UpdateProfile(string gender, string UserName, string emailId)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@UL_Gender", gender),
new SqlParameter("@UL_User_Name", UserName),
new SqlParameter("@UL_EmailId", emailId)
};
bool result;
SqlDBHelper objDB = new SqlDBHelper();
string sQuery = "UPDATE RTM_User_List SET UL_EmailId=@UL_EmailId, UL_Gender=@UL_Gender WHERE UL_System_User_Name = @UL_User_Name";
result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
// string sQuery = "UPDATE RTM_User_List SET UL_EmailId='" + emailId + "', UL_Gender='" + gender + "' WHERE UL_System_User_Name = '"+ UserName +"'";
//result = objDB.DBExecuteNoNQuery(sQuery);
return(result);
}
/// <summary>
/// 添加一个团购单
/// </summary>
/// <param name="ticket"></param>
/// <returns></returns>
public static bool AddGroupBuyTicket(GroupBuyTicketModel ticket)
{
bool result = false;
string sqlCmd = String.Format(AddGroupBuyTicketSqlCmdTemplate,
ticket.Location,
ticket.Title,
ticket.Img,
ticket.StartDate,
ticket.EndDate,
ticket.ProductionTotalCount,
ticket.RelatedProductSysNo,
ticket.Price,
ticket.CountLimit);
SqlDBHelper dbHelper = new SqlDBHelper();
if (dbHelper.ExecuteNonQuery(sqlCmd) > 0)
{
result = true;
}
return(result);
}
public void AddLogs(string UA_Action, string UA_Table, string UA_Action_By, DateTime UA_Action_Time)
{
try
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@UA_Action", UA_Action),
new SqlParameter("@UA_Table", UA_Table),
new SqlParameter("@UA_Action_By", UA_Action_By),
new SqlParameter("@UA_Action_Time", UA_Action_Time),
};
sQuery = "insert into dbo.RTM_Audit_Trail (UA_Action, UA_Table, UA_Action_By, UA_Action_Time) " +
"values(@UA_Action, @UA_Table, @UA_Action_By,@UA_Action_Time)";
objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
}
catch (Exception ex)
{
}
}
public bool UpdateImages(int ticketId, string empId)
{
bool result;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ticketId", ticketId),
new SqlParameter("@empId", empId)
};
string sQuery = "UPDATE RTM_Ticket_Attachments SET I_TicketId =@ticketId WHERE I_TicketId=0 and I_EmpId =@empId";
//result = objDBL.DBExecuteNoNQuery(sQuery);
result = objDBL.ExecuteNonQuery(sQuery, CommandType.Text, parameters);
return(result);
}
public int UpdateChildSkill(ChildSkill childSkill)
{
int success = 0;
try
{
object[] param =
{
childSkill.Id,
childSkill.ChildSkillName,
childSkill.ChildSkillDesctiption,
childSkill.MainSkillId,
childSkill.Active,
childSkill.CreatedBy
};
success = SqlDBHelper.ExecuteNonQuery(_connection, StoredProcedures.sp_UpdateChildSkill,
param);
}
catch (Exception ex)
{
}
return(success);
}
private static bool UpdateTicketInitialAllocatedQtyAndStatus(string gid, int status, int productSysNo)
{
bool result = false;
string getInitialAllocatedQtySqlTxt = String.Format(GetInitialAllocatedQtySqlCmd, productSysNo);
SqlDBHelper dbHelper = new SqlDBHelper();
try
{
DataTable data1 = dbHelper.ExecuteQuery(getInitialAllocatedQtySqlTxt);
if (data1.Rows.Count > 0)
{
int initialAllocatedQty = int.Parse(data1.Rows[0]["saledBefore"].ToString());
string updateInitialAllocatedQtySqlTxt = String.Format(UpdateInitialAllocatedQtyAndStatusSqlCmd, status, initialAllocatedQty, gid);
if (dbHelper.ExecuteNonQuery(updateInitialAllocatedQtySqlTxt) > 0)
{
result = true;
}
}
}
catch
{
}
return(result);
}
private static bool UpdateTicketStatus(string gid, int status)
{
bool result = false;
SqlDBHelper dbHelper = new SqlDBHelper();
string updateStatusSqlTxt = String.Format(UpdateTicketStatusSqlCmd, status, gid);
try
{
if (dbHelper.ExecuteNonQuery(updateStatusSqlTxt) > 0)
{
result = true;
}
}
catch
{
}
return result;
}
private static bool UpdateTicketInitialAllocatedQtyAndStatus(string gid, int status, int productSysNo)
{
bool result = false;
string getInitialAllocatedQtySqlTxt = String.Format(GetInitialAllocatedQtySqlCmd, productSysNo);
SqlDBHelper dbHelper = new SqlDBHelper();
try
{
DataTable data1 = dbHelper.ExecuteQuery(getInitialAllocatedQtySqlTxt);
if (data1.Rows.Count > 0)
{
int initialAllocatedQty = int.Parse(data1.Rows[0]["saledBefore"].ToString());
string updateInitialAllocatedQtySqlTxt = String.Format(UpdateInitialAllocatedQtyAndStatusSqlCmd, status, initialAllocatedQty, gid);
if (dbHelper.ExecuteNonQuery(updateInitialAllocatedQtySqlTxt) > 0)
{
result = true;
}
}
}
catch
{
}
return result;
}
/// <summary>
/// 添加一个团购单
/// </summary>
/// <param name="ticket"></param>
/// <returns></returns>
public static bool AddGroupBuyTicket(GroupBuyTicketModel ticket)
{
bool result = false;
string sqlCmd = String.Format(AddGroupBuyTicketSqlCmdTemplate,
ticket.Location,
ticket.Title,
ticket.Img,
ticket.StartDate,
ticket.EndDate,
ticket.ProductionTotalCount,
ticket.RelatedProductSysNo,
ticket.Price,
ticket.CountLimit);
SqlDBHelper dbHelper = new SqlDBHelper();
if (dbHelper.ExecuteNonQuery(sqlCmd) > 0)
{
result = true;
}
return result;
}