public static bool ex_update_insql(Borrow br)
{
try
{
Sq_h.run_rn(string.Format(
"Update dbo.borrow set rdID = '{0}',bkID = '{1}',IdContinueTimes = '{2}',ldDateOut = '{3}',ldDateRetPlan = '{4}',ldDateRetAct = '{5}',ldOverDay = '{6}',ldOverMoney = '{7}',ldPunishMoney = '{8}',IsHasReturn = '{9}',OperatorLend = '{10}',OperatorRet = '{11}' where BorrowID = '{12}'",
br.rdID, br.bkID, br.IdContinueTimes, Sq_h.match(br.ldDateOut), Sq_h.match(br.ldDateRetPlan), Sq_h.match(br.ldDateRetAct), br.ldOverDay, br.ldOverMoney, br.ldPunishMoney, br.IsHasReturn, br.OperatorLend, br.OperatorLend, br.BorrowID));
return(true);
}
catch (SqlException e)
{
return(false);
throw new Exception(e.Message);
}
}
public static bool ex_insert_insql(Borrow br)
{
try
{
Sq_h.run_rn(string.Format(
"Insert into dbo.borrow (BorrowID,rdID,bkID,IdContinueTimes,ldDateOut,ldDateRetPlan,ldDateRetAct,ldOverDay,ldOverMoney,ldPunishMoney,IsHasReturn,OperatorLend,OperatorRet) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')",
br.BorrowID, br.rdID, br.bkID, br.IdContinueTimes, Sq_h.match(br.ldDateOut), Sq_h.match(br.ldDateRetPlan), Sq_h.match(br.ldDateRetAct), br.ldOverDay, br.ldOverMoney, br.ldPunishMoney, br.IsHasReturn, br.OperatorLend, br.OperatorRet));
return(true);
}
catch (SqlException e)
{
return(false);
throw new Exception(e.Message);
}
}
public static bool ex_update_insql(Book bk)
{
try
{
Sq_h.run_rn(string.Format(
"Update dbo.book Set bkCode='{0}',bkName='{1}',bkAuthor='{2}',bkPress ='{3}',bkDatePress='{4}',bkLanguage='{5}',bkPages='{6}',bkPrice='{7}', bkDateIn='{8}',bkBrief='{9}',bkCover='{10}',bkStatus = '{11}' where bkID = '{12}'",
bk.bkCode, bk.bkName, bk.bkAuthor, bk.bkPress, Sq_h.match(bk.bkDatePress), bk.bkLanguage, bk.bkPages, bk.bkPrice, Sq_h.match(bk.bkDateIn), bk.bkBrief, bk.bkCover, bk.bkStatus, bk.bkID
));
return(true);
}
catch (SqlException e)
{
return(false);
throw new Exception(e.Message);
}
}
public static bool ex_insert_insql(Book bk)
{
try
{
Sq_h.run_rn(string.Format(
"Insert into dbo.book (bkID,bkCode,bkName,bkAuthor,bkPress ,bkDatePress,bkLanguage,bkPages,bkPrice, bkDateIn,bkBrief,bkCover,bkStatus) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}')",
bk.bkID, bk.bkCode, bk.bkName, bk.bkAuthor, bk.bkPress, Sq_h.match(bk.bkDatePress), bk.bkLanguage, bk.bkPages, bk.bkPrice, Sq_h.match(bk.bkDateIn), bk.bkBrief, bk.bkCover, bk.bkStatus
));
return(true);
}
catch (SqlException e)
{
return(false);
throw new Exception(e.Message);
}
}