为什么我写的这个方法报错!高手进来看看
冷月孤峰 2004-01-29 03:57:16 报错:
C:\Inetpub\wwwroot\Business\SheetNo.cs(34): “Business.SheetNo.CreateSheetNo(decimal, string, string, decimal, out string)” : 并非所有的代码路径都返回值
原代码:
public int CreateSheetNo(decimal cllyid,string clly, string jzy,decimal employeeid,out string retStr )
{//生成送货单编号(材料来源ID+用户ID+结帐月+4位流水号)
OleDbConnection cnn=null;
OleDbDataReader retRecord=null;
OleDbCommand objCmd=null;
string sqlStr=null;
retStr="";
if(jzy.Length!=6)
{
_ErrMsg="记帐月位数不够";
return -1;
}
else
{
try
{
cnn=new OleDbConnection(_cnnStr);
cnn.Open();
sqlStr="select max(sheetno) from twsheet where ifs is null and clly=?clly and jzy=?jzy and employeeid=?employeeid";
objCmd=new OleDbCommand(sqlStr,cnn);
objCmd.Parameters.Add("?clly",OleDbType.Numeric);
objCmd.Parameters.Add("?jzy",OleDbType.VarChar,10);
objCmd.Parameters.Add("?employeeid",OleDbType.Numeric);
objCmd.Parameters["?clly"].Value=cllyid;
objCmd.Parameters["?jzy"].Value=jzy ;
objCmd.Parameters["?employeeid"].Value=employeeid;
retRecord=objCmd.ExecuteReader();
while(retRecord.Read())
{
if(retRecord.Read())
{
System.Int64 xsl=Convert.ToInt64( retRecord.GetString(0))+1;
string xslxh=Convert.ToString(xsl);
retStr =clly+ employeeid + jzy + xslxh.Substring(xslxh.Length-4,4) ;
return 0;
}
else
{
retStr=clly + employeeid + jzy+"0001";
return 0;
}
}
}
catch(Exception e)
{
_ErrMsg=e.Message;
return -1;
}
finally
{
if(retRecord!=null)
retRecord.Close();
if(objCmd!=null)
objCmd.Dispose();
if(cnn!=null)
cnn.Close();
}
}
}